进入目录:cd /home/apb/mysql
初始化mysql:
./bin/mysqld --defaults-file=/home/username/mysql/conf/my.cnf --initialize --user='username’
启动mysql:
./bin/mysqld_safe --defaults-file=/home/username/mysql/conf/my.cnf &
配置mysql环境变量:
echo “export PATH=$PATH:/home/username/mysql/bin”>> /home/username/.bashrc
加载环境变量:source /home/username/.bashrc
查看mysql初始的root密码:cat /home/apb/mysql/log/error.log | grep password
使用初始密码登录后,设置root密码(假设 “abc123”):
set password=password(‘abc123’);
添加mysql用户:test 密码:test2020
root登录mysql服务器执行:
grant all privileges on *.* to test@"%" identified by “test2020” with grant option;
flush privileges;
quit;