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
mysql在lunix安装
最新推荐文章于 2024-08-13 17:09:48 发布