[root@mymaster1 mysql]# vi /etc/init.d/mysql
把下面的
basedir=
datadir=
修改为
basedir=/data/mysql
datadir=/data/mysql/data
9. 启动数据库
[root@mymaster1 mysql]# service mysql start
Starting MySQL[确定]
10. 修改数据库root密码
[root@mymaster1 mysql]#/data/mysql/bin/mysqladmin -u root password 'wengjixi'
[root@mymaster1 mysql]#/data/mysql/bin/mysqladmin -u root -h mymaster1.localdomain password 'wengjixi'
11. 修改环境变量，把mysql执行文件路径添加到环境变量中
[root@mymaster1 mysql]# vi /etc/profile
PATH=$PATH:/data/mysql/bin
export PATH
[root@mymaster1 mysql]# source /etc/profile
12. 测试登录
[root@mymaster1 mysql]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.6.19 MySQL CommunityServer (GPL)
Copyright (c) 2000, 2014, Oracle and/or itsaffiliates. All rights reserved.
Oracle is a registered trademark of OracleCorporation and/or its
affiliates. Other names may be trademarksof their respective
owners.
Type 'help;' or '\h' for help. Type '\c' toclear the current input statement.
mysql>
mysql> show variables like '%data%';
+-------------------------------+------------------------+
| Variable_name | Value |
+-------------------------------+------------------------+
| character_set_database | latin1 |
| collation_database | latin1_swedish_ci |
| datadir | /data/mysql/data/