linux中mysql数据库配置_linux中mysql源码安装---操作配置数据库

1、安装默认的数据库

添加MySQL用户和用户组

[root@node1 ~]# groupadd mysql

[root@node1 ~]# useradd -g mysql mysql

进入安装目录，将程序二进制的所有权改为root，数据目录的说有权改为mysql用户，更新授权表

[root@node1 mysql-5.5.22]# cd /usr/local/mysql/

[root@node1 mysql]# chown -R root .

[root@node1 mysql]# chown -R mysql .

[root@node1 mysql]# chgrp -R mysql .

[root@node1 mysql]# scripts/mysql_install_db --user=mysql

2016-01-08 12:13:03 3745 [Note] Binlog end

2016-01-08 12:13:03 3745 [Note] InnoDB: FTS optimize thread exiting.

2016-01-08 12:13:03 3745 [Note] InnoDB: Starting shutdown...

2016-01-08 12:13:05 3745 [Note] InnoDB: Shutdown completed; log sequence number 1625987

OK

To start mysqld at boot time you have to copy

support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PAS