MYSQL数据库MySQL 5.7.13 源码编译安装配置方法图文教程

6、配置mysql服务MYSQL应用

shell> cp support-files/mysql.server /etc/init.d/mysqld
shell> chkconfig --add mysqld  # 添加到系统服务
shell> chkconfig mysqld on  # 开机启动

7、启动服务MYSQL应用

shell> service mysqld start  # 启动mysql服务
shell> service mysqld stop  # 停止mysql服务
shell> service mysqld restart  # 重新启动mysql服务

8、设置数据库密码MYSQL应用

shell> /usr/local/mysql/bin/mysql -e "grant all privileges on *.* to root@'127.0.0.1' identified by "root" with grant option;"
shell> /usr/local/mysql/bin/mysql -e "grant all privileges on *.* to root@'localhost' identified by "root" with grant option;"
# 开启远程登录(将host设为%即可)
/usr/local/mysql/bin/mysql -e "grant all privileges on *.* to root@'%' identified by "root" with grant option;"

9、配置mysql环境变量MYSQL应用

shell> vim /etc/profile
shell> export PATH=/usr/local/mysql/bin:$PATH
shell> source /etc/profile

四、其它注意事项MYSQL应用

如果中途编译失败了,需要删除cmake生成的预编译配置参数的缓存文件和make编译后生成的文件,再重新编译.MYSQL应用

shell> cd /opt/mysql-server
shell> rm -f CMakeCache.txt
shell> make clean

以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持编程之家PHP.
MYSQL应用

（编辑：威海站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!