1.卸载centos自带的mysql
直接使用rpm -e --nodeps 'rpm -qa | grep mysql'
卸载
或者使用rpm -qa | grep mysql
查找已安装的mysql文件
再将查找内容用rpm -e --nodeps XXX
卸载
2.上传
通过rz
命令上传安装文件
mysql服务端
MySQL-server-5.5.8-1.rhel5.x86_64.rpm
下载地址
mysql客户端
MySQL-client-5.5.8-1.rhel5.x86_64.rpm
下载地址
3.安装
安装服务端
rpm -ivh MySQL-server-5.5.8-1.rhel5.x86_64.rpm –nodeps –force
安装客户端
rpm -ivh MySQL-client-5.5.8-1.rhel5.x86_64.rpm –nodeps –force
4.运行mysql服务端
## 运行
service mysql start
## 停止
service mysql stop
## 重启
service mysql restart
5.添加密码
## 添加密码
/usr/bin/mysqladmin -u root password 'XXXXXXX';
## 登录数据库
mysql -uroot -pXXXXXXX
6.修改字符编码
show variables like '%char%';
输出
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
将character_set_connection,character_set_server编码改为utf8
set character_set_database=utf8;
set character_set_server=utf8;
再次检查一遍编码
show variables like '%char%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
以上方式只能暂时修改编码
若要让修改永久有效,编辑/etc/my.cnf文件,在[mysqlId]下加入character-set-server=utf8
在有的系统中,或许会找不到这个文件,只需要到/usr/share/mysql目录下,拷贝任一my-*.cnf(就是以my开头的配置文件)到/etc下并改名即可。
7.允许远程登录
1.进入 mysql:
mysql -u root -pXXXXX;
2.使用 mysql库 :
use mysql;
3.授权用户 :
grant all privileges on *.* to root@'%' identified by 'XXXXX'(密码);
4.强制刷新权限 :
flush privileges;
5.测试:
在windows上使用navicat进行连接测试
在图形界面新建一个数据库进行测试
在centos上查看
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| _mytest |
| mysql |
| performance_schema |
| test |
+--------------------+
如果有刚刚建成的数据库,连接成功