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