mysql在lunix安装

来源：互联网发布：北京php招聘编辑：程序博客网时间：2024/05/29 12:36

1 把已经下载好的（F:\softplace\develop\bigData\mysql）上传到 lunix /home/bigdata/mysql
MySQL-client-5.6.17-1.linux_glibc2.5.i386.rpm MySQL-devel-5.6.17-1.linux_glibc2.5.i386.rpm MySQL-server-5.6.12-1.linux_glibc2.5.i386.rpm

2 分别执行
2.1 rpm -ivh MySQL-server-5.6.12-1.linux_glibc2.5.i386.rpm
生成随机密码在 more /root/.mysql_secret
2.2 rpm -ivh MySQL-client-5.6.17-1.linux_glibc2.5.i386.rpm

2.3 rpm -ivh MySQL-devel-5.6.17-1.linux_glibc2.5.i386.rpm

3 修改密码为123

3.1 mysqld_safe --user=mysql --skip-grant-tables --skip-networking &

3.2 mysql -u root mysql //这样能登陆密码为空

3.3 mysql> UPDATE user SET Password=PASSWORD('123') where USER='root' and host='root' or host='localhost';
mysql> FLUSH PRIVILEGES;
mysql> quit
3.4 mysqld restart

3.5 mysql -uroot -p
//输入123

3.6 mysql> SET PASSWORD = PASSWORD('123');


windows 连接mysql 服务被拒绝

mysql> CREATE USER 'storm' IDENTIFIED BY '123';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
mysql> flush privileges;

sqlyog连接用户名storm 密码 123 地址192.168.119.132