Centos5下MySQL的安装步骤

Centos5下MySQL的安装步骤

CentOS5下MySQL的安装步骤

创建mysql用户组和用户
[root@centos ]# groupadd mysql
[root@centos ]# useradd -g mysql mysql
[root@centos ]# cd homexule
[root@centos ]# chmod 755 mysql-5.0.22.tar.gz

编译并安装MySQL
[root@centos ]# tar zxvf mysql-5.0.22.tar.gz
[root@centos ]#cd mysql-5.0.22
[root@centos mysql-5.0.22]  .configure --prefix=usrlocalmysql
[root@centos mysql-5.0.22]  make
[root@centos mysql-5.0.22]  make install

配置并启动MySQL
[root@centos mysql-5.0.22]# cp support-filesmy-medium.cnf etcmy.cnf
[root@centos mysql-5.0.22]# cd usrlocalmysql
[root@centos mysql]# binmysql_install_db --user=mysql
Installing all prepared tables
Fill help tables
To start mysqld at boot time you have to copy support-filesmysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands
usrlocalmysqlbinmysqladmin -u root password 'new-password'
usrlocalmysqlbinmysqladmin -u root -h centos.job100.com password 'new-password'
See the manual for more instructions.

You can start the MySQL daemon with
cd usrlocalmysql ; usrlocalmysqlbinmysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory
cd sql-bench ; perl run-all-tests

Please report any problems with the usrlocalmysqlbinmysqlbug script!

The latest information about MySQL is available on the web at
httpwww.mysql.com
Support MySQL by buying supportlicenses at httpshop.mysql.com

[root@centos mysql]# binmysqld_safe --user=mysql &
[1] 20100
[root@centos mysql]# Starting mysqld daemon with databases from usrlocalmysqlvar