mysql 安装步骤

来源:互联网 发布:淘宝怎么发布产品 编辑:程序博客网 时间:2024/06/16 00:47
1.rpm -qa|grep -i mysql


:mysql-libs-5.1.66-2.el6_3.i686


2.rpm -e mysql-libs-5.1.66-2.el6_3.i686  --nodeps


3.groupadd mysql


4.useradd -r -g mysql mysql


5. tar -zxvf /app/mysql-5.7.20-linux-glibc2.12-i686.tar.gz




6.ln -s mysql-5.7.20-linux-glibc2.12-x86_64/ mysql




7.chown -R mysql .


8.chgrp -R mysql .


9.mkdir data


10.bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/


11. cp -a ./support-files/mysql.server  /etc/init.d/mysqld


12.chkconfig --add mysqld




13.chkconfig --list mysqld


14.service mysqld start


15. netstat -anp|grep mysqld




16.service mysqld stop


17. ./mysqld_safe --user=mysql --skip-grant-tables --skip-networking &


18. ./mysql -u root mysql


19.use mysql 


20.update user set authentication_string=password('201026') where user='root'


21.flush privileges;


22.service mysqld stop


23.service mysqld start


24. vi /etc/sysconfig/iptables


25.-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT


26.service iptables restart