Real Life Tech Problems Solved.
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 [...]
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
Article how to install PostgreSQL server and PostGIS on Fedora 14
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 [...]
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 [...]