Sometimes when the slave gets out of sync with the Master, the best thing is to just start again with a fresh copy from the Master.
Real Life Tech Problems Solved.
ERROR 6 (HY000): Error on delete of (Errcode: 13)’./database//db.opt’ when trying to DROP a MySQL database
To add a new user to MySQL perform the following In PuTTY log into your server with MySQL on it and open MySQL using the following command mysql -u root -p It will now as for your password which you should type in Now set up your users, you can limit where a user can [...]
To start MySql Server automatically on a CentOS box simply issue the following command as root: chkconfig –levels 235 mysqld on You can also use this to autostart Apache: chkconfig –levels 235 httpd on
After a new install of MySql when trying to connect remotly I was getting the following error: Host ‘xxx.xxx.xxx.xxx’ is not allowed to connect to this MySQL server To solve this I needed to SSH into my server using PuTTY and perform the following commands: mysql -u root -p [enter in your password] CREATE USER [...]
Article detailing how to install Apache, MySQL and PHP on a Rackspace Cloud Fedora instance