centos6.5上安装mysql过程

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/ |
+--------------------------+----------------------------+