CentOS安装mysql

0，安装mysql

#yum search mysql

#yum install mysql-server.x86_64

#yum install mysql.x86_64

mysql没有自动启动起来

1，更改数据库路径

建立数据库数据存放路径

#mkdir /mnt/mysql

将目录所有者改为mysql

#chown mysql.mysql mysql

2，修改/etc/my.cnf

[mysqld]
datadir=/mnt/mysql
socket=/mnt/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0


[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

3，修改/etc/rc.d/init.d/mysqld

#vi /etc/rc.d/init.d/mysqld

找到get_mysql_option mysqld datadir "/mnt/mysql"，修改

4，启动mysql

#/etc/rc.d/init.d/mysqld start

5，客户端登录

#mysql

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

解决：修改/etc/my.cnf，增加[client]配置，如下：

[client]
socket=/mnt/mysql/mysql.sock

再次登录客户端：

#mysql

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.73 Source distribution


Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.


Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


mysql> 

mysql成功安装。

6，修改密码：

必须在mysql已经启动的前提下才能修改密码成功：

#mysqladmin -u root password new-password

7，用新密码登录

#mysql -u root -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 5.1.73 Source distribution


Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.


Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


mysql> exit
Bye

8，停止mysql

#/etc/rc.d/init.d/mysqld stop