/data/mysql/scripts
./mysql_install_db –defaults-file=/etc/my.cnf –user=mysql –basedir=/data/mysql \
–datadir=/data/mysql/data
6.启动MySQL
chown -R mysql /data/mysql
chgrp -R mysql /data/mysql
–6.1建议安全启动
/data/mysql/bin/mysqld_safe &
/data/mysql/bin/mysqld_safe –datadir=’/data/mysql/data’ &
–6.2添加服务，拷贝服务脚本到init.d目录，并设置开机启动
cd /data/mysql/
cp support-files/mysql.server /etc/init.d/mysql
chkconfig mysql on
7.配置mysql用户
MySQL启动成功后，root默认没有密码，我们需要设置root密码。
7.1修改/etc/profile文件，在文件末尾添加
vi + /etc/profile
PATH=/data/mysql/bin:$PATH
export PATH
source /etc/profile
现在，我们可以在终端内直接输入mysql进入，mysql的环境了
执行下面的命令修改root密码
–7.2修改mysql管理员密码
1.修改当前用户密码
mysql -uroot -p
SET PASSWORD = PASSWORD(‘pass01’);
flush privileges;
2.给所有的root用户设定密码：
第一种方式(推荐)
# mysql -uroot -p
MariaDB [(none)]>
MariaDB [(none)]> select host,user,password from mysql.user;
+————-+——+———-+
| host | user | password |
+————-+——+———-+
| localhost | root | |
| db02.zp.com | root | |
| 127.0.0.1 | root | |
| ::1 | root | |
| localhost | | |
| db02.zp.com | | |
+————-+——+———-+
6 rows in set (0.00 sec)
update mysql.user set password = password(‘pass01’) where user = ‘root’ limit 100;flush privileges;
flush privileges;
3.删除所有匿名用户(不要删除root@localhost)
DROP USER ”@’localhost’;delete from mysql.user where user=” limit 10;commit;flush privileges;
delete from mysql.user where host=’db01.mysql.com’;flush privileges;
delete from mysql.user where host=’db02.mysql.com’;flush privileges;
delete from mysql.user where host=’db03.mysql.com’;flush privileges;
–7.3设置root用户可以远程访问
–方法1：授权法
mysql>GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘pass01’ \
WITH GRANT OPTION;flush privileges;
select host,user,password from mysql.user;
–7.4 登录mysql
mysql -hlocalhost -uroot -ppass01
—-7.5设置linux脚本
vi + ~/.bash_profile
ocpyang set(绑定mysql到内网IP只能写内网IP)
alias mysql=”mysql -U -hlocalhost -uroot -ppass01 –auto-rehash”
alias errorlog=”cat /data/mysql/mysql_logs/error_log/error.log”
alias mycnf=”cd /data/mysql”
export PATH=/data/mysql/scripts:$PATH
source ~/.bash_profile
—-7.7修改权限
chown -R mysql /data/mysql
chgrp -R mysql /data/mysql
—-7.8 常见启动错误或警告
cat /data/mysql/mysql_logs/error_log/error.log
Warning] ‘proxies_priv’ entry ‘@% root@mysql.ocp.com’ ignored in –skip-name-resolve mode.
解决办法:
delete from mysql.proxies_priv where host=’db01.mysql.com’;commit;flush privileges;
delete from mysql.proxies_priv where host=’db02.mysql.com’;commit;flush privileges;
delete from mysql.proxies_priv where host=’db03.mysql.com’;commit;flush privileges;
—–7.9 软连接mysql的bin目录
ln -sf /data/mysql/bin/* /usr/bin/
3.galera相关配置
—–3.1 galera安装(参见galera安装配置)
—3.2 新建wsrep用户
GRANT RELOAD, LOCK TABLES, REPLICATION CLIENT ON . TO ‘wsrep’@’%’ IDENTIFIED BY ‘wsrep’ ;flush privileges;
CREATE USER ‘wsrep’@’localhost’ IDENTIFIED BY ‘wsrep’;
GRANT RELOAD, LOCK TABLES, REPLICATION CLIENT ON . TO ‘wsrep’@’localhost’;
FLUSH PRIVILEGES;
—3.2.3 安装socat
http://www.dest-unreach.org/socat/
http://www.dest-unreach.org/socat/download/
tar xf socat-1.7.3.0.tar.gz
cd socat-1.7.3.0
./configure
make -j4
make install
—3.2.4 修改mysql的配置文件
mkdir /etc/my.cnf.d
cd /soft/mariadb-10.0.20/support-files
cp wsrep.cnf /etc/my.cnf.d/
vi /etc/my.cnf.d/wsrep.cnf
node01
[mysqld]
wsrep_on=ON
binlog_format=ROW
default-storage-engine=innodb
为了降低冲突
innodb_auto