p; #创建程序目录
mv /server/tools/mysql-5.6.34-*-x86_64 /application/mysql-5.6.34
#将程序搬迁
4) 为mysql服务程序创建软链接
ln -s /application/mysql-5.6.34/ /application/mysql
#创建软连接
5) 让mysql用户管理 /application/mysql/
chown -R mysql.mysql /application/mysql/data
## 用虚拟用户管理
6) 初始化数据库
#1. 确认软件安装在哪里
#2. 确认数据存放在哪里
#3. 确认MySQL使用的用户谁?
/application/mysql/scripts/mysql_install_db --basedir=/application/mysql --datadir=/application/mysql/data --user=mysql
==================================================================================================
下面是解释
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
mysql启动脚本 默认放在support-files/mysql.server
记得给MySQL设置个密码
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
创建密码的代码
/application/mysql/bin/mysqladmin -u root password 'new-password'
远程创建密码
/application/mysql/bin/mysqladmin -u root -h web01 password 'new-password'
==================================================================================================
7) 复制启动脚本 授权
cp /application/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
8) 修改启动脚本 和 mysql命令中的路径
sed -i 's#/usr/local/mysql#/application/mysql#g' /application/mysql/bin/mysqld_safe /etc/init.d/mysqld
#将默认的东西改为自己的 将后面两个配置文件的全部都`修改
9) 复制默认的配置文件
\cp /application/mysql/support-files/my-default.cnf /et