编译安装mysql-5.5.33
时间:2022-03-14 02:24
操作系统 | centos 6.4 x86_64 |
mysql版本 | 5.5.33 |
//创建服务脚本
# cp support-files/mysql.server /etc/init.d/mysqld
# chmod +x /etc/init.d/mysqld
# chkconfig --add mysqld
# chkconfig mysqld on
//初始化mysql系统数据库
# scripts/mysql_install_db --user=mysql --datadir=/mysqldata
//修改环境变量
# echo "export PATH=$PATH:/usr/local/mysql/bin" > /etc/profile.d/mysql.sh
# . /etc/profile.d/mysql.sh
5. 修改默认密码
# service mysqld start
# mysql -uroot -p //回车,默认为空密码
mysql>
方法一:
mysql> SET PASSWORD FOR ‘root‘@‘localhost‘ = PASSWORD(‘12345‘);
方法二:
mysql> UPDATE user SET password = PASSWORD(‘12345‘) WHERE user = ‘root‘;
mysql> FLUSH PRIVILEGES;
方法三:
# mysqladmin -uroot -hlocalhost password ‘new12345‘ -p
# mysqladmin -uroot -hlocalhost -p flush-privileges
6. 删除匿名用户
mysql> select user,host,password from mysql.user;
+------+-----------------------+-------------------------------------------+
| user | host | password |
+------+-----------------------+-------------------------------------------+
| root | localhost | *96073409CD134870AF004F84332F73924C906E9A |
| root | localhost.localdomain | |
| root | 127.0.0.1 | |
| root | ::1 | |
| | localhost | |
| | localhost.localdomain | |
+------+-----------------------+-------------------------------------------+
6 rows in set (0.00 sec)
//删除最后两行
mysql> drop user ‘‘@‘localhost‘;
mysql> drop user ‘‘@‘localhost.localdomain‘;
本文出自 “” 博客,请务必保留此出处