Real life problems solved

Advert

Recopy Master Database to Slave on Fedora 14 Rackspace Cloud when out of Sync

Posted by on Sep 12, 2011 in Fedora, MySql, Rackspace Cloud | 0 comments

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 More

ERROR 6 (HY000): Error on delete of ‘./database//db.opt’ (Errcode: 13)

Posted by on Dec 14, 2010 in MySql | 0 comments

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 More

MySQL add new user

Posted by on Oct 14, 2010 in MySql | 0 comments

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 More

Autostart MySQL on CentOS

Posted by on Sep 21, 2010 in CentOS, MySql | 0 comments

To start MySql Server automatically on a CentOS box simply issue the following command as root: chkconfig --levels 235 mysqld on You can...

Read More

MySql Host is not allowed to connect to this MySQL server

Posted by on Sep 3, 2010 in Fedora, MySql | 0 comments

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
Adsense