二进制 mysql 的安装步骤
一、安装 mysql:# yum -y install gcc glibc libaio libstdc++ libstdc ncurses-libs# yum install gcc gcc-c++# yum install ncurses ncurses-devel# mkdir -p /usr/local/src# cd /usr/local/src# rz+软件名# tar xf mysql-5.7.17-linux-glibc2.5-i686.tar.gz# useradd mysql -s /sbin/nologin -M# mv mysql-5.7.17-linux-glibc2.5-i686/usr/local/mysql# cd /usr/local/mysql#ln -s mysql-5.7.17-linux-glibc2.5-i686 mysql# chown -R mysql . # chgrp -R mysql . # bin/mysqld --initialize --user=mysql#生成的密码要记住:root@localhost: 1daeiqUjJL_q # chown -R root . # mkdir -p /usr/local/mysql/data#chown -R mysql data # bin/mysqld_safe --user=mysql &# cp support-files/mysql.server /etc/init.d/mysql # chkconfig --add mysql# chkconfig --level 2345 mysql on# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld # chkconfig mysqld on # service mysqld start Starting MySQL.. SUCCESS! # service mysqld restart Shutting down MySQL.. SUCCESS! Starting MySQL.. SUCCESS!
二、添加环境变量:# vim /etc/profile export PATH=$PATH:/usr/local/mysql/bin
# source /etc/profile
补充:通过配置my.cnf mysql选项socket文件位置解决# service mysqld stopShutting down MySQL.. SUCCESS! # vim /etc/my.cnf在最后增加即可:
1
<br>
no-auto-rehashsocket = /var/lib/mysql/mysql.sock# service mysqld startStarting MySQL.. SUCCESS! # mysql -uroot -p
三、访问数据库,用安装时给的随机密码进行第一次登录:# mysql -uroot -p
四、怎么修改 mysql 数据库的随机密码mysql> set password for 'root'@localhost = password ('123456');Query OK, 0 rows affected, 1 warning (0.00 sec)# mysql -uroot -pEnter password:Welcome to the MySQL monitor.Commands end with ; or \g.Your MySQL connection id is 5Server version: 5.7.17 MySQL Community Server (GPL)
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
页:
[1]