MySQL5 Setup RH

From PhoenixWing

Jump to: navigation, search

Install the MySQL.com RPM packages, in this example: 

MySQL-client-5.0.37-0.i386.rpm
MySQL-devel-5.0.37-0.i386.rpm
MySQL-server-5.0.37-0.i386.rpm
MySQL-shared-compat-5.0.37-0.i386.rpm

Once installed, run mysql_install_db to create system database and populate the default data directory of /var/lib/mysql.


Next, tighten down default security using the mysql_secure_installation command. This will prompt you to change the root password, remove anonymous users, remove the test database, and prevent root from logging in anywhere except via 'localhost'.


As of MySQL5, you should also install timezone data using: mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql. This is needed and useful for multi-user database systems utilizing new MySQL5 features, especially e-commerce.

Retrieved from "http://www.phoenixwing.com/wiki/MySQL5_Setup_RH"
Personal tools