I assume for this you have already got a database setup with data in it. Install Slave Start up a new Fedora 15 instance in Rackspace Open SSH using Putty and do the following: yum install mysql mysql-server /etc/init.d/mysqld start /usr/bin/mysql_secure_installation When asked for current password just press enter. Then set a root password (make it secure), remove anonymous users, disallow root login remotely and remove the test database. Finally reload the privilege tables. To [...]

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.

Fix Lost connection to MySQL server at ‘reading initial communication packet’, system error: 0 on Rackspace Cloud

I have recently been playing around with MySQL Spatial functionality. Although not complete by any means it is a good way to start thinking of storing your location based data. One of the most useful things to do is find the distance between two points. There is a place-holder in MySQL 5 called DISTANCE, however this isn’t yet implemented.

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 log in from by changing the ‘@’%’. % means from anywhere, localhost ‘@’localhost’ would mean just from the local computer, [...]

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

Got this error when trying to use MySql in a PHP page on a Fedora install. What had happened is PHP wasn’t installed with MySql support. However it is simple to fix. Open up PuTTY and enter in the following: yum install php-mysql /sbin/service httpd restart

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 ‘techproblems’@'%’ IDENTIFIED BY ‘MyC0MPL3XPa33W0RD’; GRANT ALL PRIVILEGES ON *.* TO ‘techproblems’@'%’ WITH GRANT OPTION; Once I had done this I [...]

Article detailing how to install Apache, MySQL and PHP on a Rackspace Cloud Fedora instance