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.
Blog
Real Life Tech Problems Solved.
ERROR 6 (HY000): Error on delete of ‘./database//db.opt’ (Errcode: 13)
ERROR 6 (HY000): Error on delete of (Errcode: 13)’./database//db.opt’ when trying to DROP a MySQL database
MySQL add new user
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 [...]
Autostart MySQL on CentOS
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
MySql Host is not allowed to connect to this MySQL server
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 [...]
Install Apache, MySql and PHP on Rackspace Cloud Fedora Server
Article detailing how to install Apache, MySQL and PHP on a Rackspace Cloud Fedora instance