Recopy Master Database to Slave on Fedora 14 Rackspace Cloud when out of Sync
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.
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.
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