Installing MySQL

Posted on November 29, 2010 by Andy Comments Off on Installing MySQL

In order to install MySQL you need to install these:

  • mysql
  • mysql-server
  • mysql-lib
  • mysql-devel

yum install mysql mysql-lib mysql-server mysql-devel

After php and php-mysql are installed you may start MySQL:

/etc/init.d/mysqld start

And you should get this:

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password ‘new-password’
/usr/bin/mysqladmin -u root -h i5 password ‘new-password’

Alternatively you can run:
/usr/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd mysql-test ; perl mysql-test-run.pl

MySQL