首页 / MYSQL / MySQl 5.7 初始化方式变更
MySQl 5.7 初始化方式变更
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了MySQl 5.7 初始化方式变更,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含2226字,纯文字阅读大概需要4分钟。
内容图文
![MySQl 5.7 初始化方式变更](/upload/InfoBanner/zyjiaocheng/1332/5c4d092d4a9b40968131f70a81548a35.jpg)
Window 64:
1.修改my-default.ini名称 ==> my.ini
[mysqld] # Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. # innodb_buffer_pool_size = 128M # Remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups. log_bin=mysql-bin # These are commonly set, remove the # and set as required. basedir = D:/MySQL/mysql-5.7.12-winx64 datadir = D:/MySQL/mysql-5.7.12-winx64/data port = 3306 server_id = 10
?2.初始化数据文件
mysqld --defaults-file=../my.ini --initialize --console
?–initialize 初始化数据文件,设置root账号密码为随机密码,注意查看输出日志
3.安装/删除mysql服务
mysqld install mysql57 sc delete mysql57
?4.启动/停止mysql
net start mysql57 net stop mysql57
?5.连接mysql ,修改root密码
ALTER USER ‘root‘@‘localhost‘ IDENTIFIED BY ‘new_password‘;
Centos :
1.创建mysql 用户
groupadd mysql useradd -r -g mysql mysql
?2.初始化数据文件
mysqld --initialize --user=mysql --datadir=./data --basedir=.
?若找不到mysqld命令,配置环境变量
MYSQL_HOME=/opt/mysql-5.7.12 PATH=$MYSQL_HOME/bin:$PATH export PATH
?3.将mysql/support-files下的my-default.cnf改名为my.cnf,拷贝到/etc目录下
[mysqld] # Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. # innodb_buffer_pool_size = 128M # Remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups. log_bin=mysql-bin # These are commonly set, remove the # and set as required. basedir = /opt/mysql/mysql-5.7.12 datadir = /opt/mysql/mysql-5.7.12/data port = 3306 server_id = 10 socket = /opt/mysql/mysql-5.7.12/tmp/mysql.sock [client] socket = /opt/mysql/mysql-5.7.12/tmp/mysql.sock
4.设置mysql以服务运行并且开机启动?
将MYSQL_HOME/ support-files/mysql.server 拷贝为/etc/init.d/mysql并设置运行权限
cp mysql.server /etc/init.d/mysql chmod +x /etc/init.d/mysql
?把mysql注册为开机启动的服务
chkconfig --add mysql
?5.启动/停止mysql
/etc/init.d/mysql start /etc/init.d/mysql stop
?6.连接mysql ,修改root密码
ALTER USER ‘root‘@‘localhost‘ IDENTIFIED BY ‘new_password‘;
闲适悦:www.xianshiyue.com? ? 共建电影分享平台
原文:http://silentwu.iteye.com/blog/2308722
内容总结
以上是互联网集市为您收集整理的MySQl 5.7 初始化方式变更全部内容,希望文章能够帮你解决MySQl 5.7 初始化方式变更所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。