Linux

Repair MySQL database

So you have a MySQL database that needs repair. The steps to follow are: For CENTOS Log in with ssh to your server and stop the MySQL server #service mysqld stop Backup all the files from all the databases to… Read More ›

MySQL basic commands

This is basically a quick set of commands for those who don’t use MySQL often. commands are in bold #log in to the server..at the terminal type mysql -u root;  #set a new password UPDATE user SET Password =PASSWORD(‘mypassword’) WHERE… Read More ›