Antoine Solutions Development A Free PHP IDE built on Open Source Software

How to install MySQL on Fedora 13

1. Install MySQL
   yum install mysql-server php-mysql

How to configure MySQL on Fedora 13

1. Set the MySQL service to start on boot
   chkconfig --levels 235 mysqld on
2. Start the MySQL service
   service mysqld start
3. Log into MySQL
   mysql -u root
4. Set the root user password for all local domains
   SET PASSWORD FOR 'root'@'localhost' = PASSWORD('new-password');
   SET PASSWORD FOR 'root'@'hostname' = PASSWORD('new-password');
   SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD('new-password');
   
5. Drop the Any user
   DROP USER ''@'localhost';
   DROP USER ''@'hostname';
   DROP USER ''@'%';
6. Drop the test database
   DROP DATABASE test;
7. Exit MySQL
   exit