Skip to main content

Posts

Showing posts with the label workbench

MySQL Workbench and MS Excel

I am a big fan of SOL Server since start of my career and will be long life may be god knows..  My SOL added in my resume in 2014. No doubt SOL Server is reach in feature and capabilities than MySQL. But today I am sharing you about MySQL's great feature that impressed me related to MySQL Excel Integration. MySQL is really very simple and light application, easy to manage and implement. Yesterday I was working on Excel and I seen an extra add ins option in Excel for MySQL Workbench. I followed the option. Really it impressed me.. Just see below…

Remote Access Enabling in MySQL using Workbench

MySQL became part of my skill set in 2014 . After installation of any instance of MySQL Server in Production or Test environment 2 nd most task for any DBA is to connect the Database from Remote. While i was new with MySQL it played with me a lot to do this task from remote machine. I hang over for 3 days and ask many ppl and search many site. Did telnet, ip-config, firewall et………….. but resolve my problem in easy through below process… 1 st Grant Remote Permission on Database Server 2 nd Configure Connection at client workbench to server

safe update mode updates in mySQL workbench error

Error Code: 1175  You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. above error came in MySQL Workbench 5.2. During executing update command on table using MySQL Workbench 5.2. while updating rows. update bl_user set user_email='smnjha989@gmail.com' where user_name='suman';