linux下mysql 5.1 和 5.7的安装教程

rpm -qa | grep mysql

rpm -e **** --nodeps

yum install mysql

yum install mysql-server 
yum install mysql-devel

/etc/my.cnf

default-character-set=utf8

service mysqld start

service mysqld stop

chkconfig --level 345 mysqld on

chkconfig --list | grep mysql

mysqladmin -u root password yourPassword

mysql -u root -p

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'yourpasswd' WITH GRANT OPTION;
FLUSH RIVILEGES;

rpm -qa | grep mysql

rpm -e **** --nodeps

tar zxvf mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz
#重命名
mv mysql-5.7.19-linux-glibc2.12-x86_64 mysql

./bin/mysqld --user=root --basedir=/opt/mysql --datadir=/opt/mysql/data --initialize

[Note] A temporary password is generated for root@localhost: **mjT,#x_5sW
"**mjT,#x_5sW"就是自动生成的初始密码!

cp my-default.cnf /etc/my.cnf

basedir=/home/mysql
datadir=/home/mysql/data

basedir=/opt/mysql
datadir=/opt /mysql/data

cp /opt/mysql/support-files/mysql.server /etc/init.d/mysqld
chkconfig --add mysqld

service mysqld start/stop