MySQL Fedora 13

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

Open Source Software: