1.查看已安装的版本
rpm -qa|grep -i mysql
2.删除已有mysql
yum remove mysql-libs 移除已经安装的mysql
命令:rm -fr /usr/lib/mysql rm -fr /usr/include/mysql 删除老版本mysql的开发头文件和库
rm -fr /var/lib/mysql 删除数据文件
rm -f /etc/my.cnf 删除配置文件
3.开始mysql
使用rz命令上传两个安装包
MySQL-client-5.6.17-1.linux_glibc2.5.x86_64.rpm
MySQL-server-5.6.17-1.linux_glibc2.5.x86_64.rpm
安装两个包
rpm -ivh MySQL-client-5.6.17-1.linux_glibc2.5.x86_64.rpm
rpm -ivh MySQL-server-5.6.17-1.linux_glibc2.5.x86_64.rpm
配置文件在/usr/my.cnf
使用/etc/init.d/mysql start 启动 或service mysql start启动
不能使用mysqladmin -u root password 123456改root密码 回报'Access denied for user 'root'@'localhost' (using password: NO)'错误
而要这样
service mysql stop 停止服务
mysqld_safe --user=mysql --skip-grant-tables --skip-networking & 跳过权限
mysql -u root mysql 进去改密码
UPDATE user SET Password=PASSWORD('newpassword') where USER='root' and host='root' or host='localhost';
FLUSH PRIVILEGES; 刷新
mysql -uroot -p 用设置的密码就能够进去了
如果程序中连不上数据库,需要修改/usr/my.cnf
# basedir = .....
datadir = /var/lib/mysql
port = 3306
# server_id = .....
socket = /var/lib/mysql/mysql.sock
如果报这种错:
java.sql.SQLException: Your password has expired. To log in you must change it using a client that supports expired passwords.
需要用set PASSWORD = PASSWORD('123')改下密码
如果用ip连数据库 会报java.sql.SQLException: Access denied for user 'root'@'oracledb' (using password: YES)这种错
SET PASSWORD FOR 'root'@'oracledb' = PASSWORD('123456'); 需要这样改下密码
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH
GRANT OPTION; 这不知道有没有用
客户端乱码解决:
查看编码:SHOW VARIABLES LIKE 'character_set%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
set names gbk; 临时改下编码就好了
SHOW VARIABLES LIKE 'character_set%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | gbk |
| character_set_connection | gbk |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | gbk |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+