Advert
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. On...
Read MoreERROR 6 (HY000): Error on delete of ‘./database//db.opt’ (Errcode: 13)
I was trying to drop a database in MySQL today but every time I did I got the error: ERROR 6 (HY000): Error on delete of...
Read MoreMySQL 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...
Read MoreAutostart 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...
Read MoreMySql 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...
Read More