find / -name mysql 查找文件
1,.d 删除vi编辑器中内容
1. 查看之前是否安装过mysql : rpm -qa|grep -i mysql
2、停止mysql服务、删除之前安装的mysql
删除命令:rpm -ev –nodeps 包名
2.查找是否包含mysql文件夹,有的话删除 : find / -name mysql
3.卸载后/etc/my.cnf不会删除,需要进行手工删除
4、再次查找机器是否安装mysql: rpm -qa|grep -i mysql
5.确认未安装后, wget 命令下载mysql安装包 : (http://dev.mysql.com/downloads/mysql/5.5.html )
RPM Package Client Utilities: MySQL-client-5.5.43-1.linux2.6.x86_64.rpm
http://dev.mysql.com/get/Downloads/MySQL-5.5/MySQL-client-5.5.43-1.linux2.6.x86_64.rpm
RPM Package MySQL Server: MySQL-server-5.5.43-1.linux2.6.x86_64.rpm
http://dev.mysql.com/get/Downloads/MySQL-5.5/MySQL-server-5.5.43-1.linux2.6.x86_64.rpm
RPM Package Development Libraries: MySQL-devel-5.5.43-1.linux2.6.x86_64.rpm
http://dev.mysql.com/get/Downloads/MySQL-5.5/MySQL-devel-5.5.43-1.linux2.6.x86_64.rpm
6.安装server
rpm MySQL-server-5.5.43-1.linux2.6.x86_64.rpm
rpm MySQL-client-5.5.43-1.linux2.6.x86_64.rpm
rpm MySQL-devel-5.5.43-1.linux2.6.x86_64.rpm
7. 设置文件夹下目录权限: /var/lib/mysql chmod 777 -R * (文件夹下有mysql-bin.index这个文件)
8. cp /usr/share/mysql/my-medium.cnf /etc/my.cnf
9.设置编码,编辑my.cnf 文件,在[mysqld]下添加以下五行:
character_set_server=utf8
character_set_client=utf8
collation-server=utf8_general_ci
lower_case_table_names=1
max_connections=1000
10.启动mysql: service mysql start
12. 修改密码(初始管理员root没有密码):umimamysqladmin -uroot password 123456 或 mysql -u root password '123456'
或者 :mysql -uroot 进入数据库,然后 SET PASSWORD = PASSWORD('123456');
13.进入数据库查看编码:
mysql> show variables like 'character_set_%';
14.设置开机启动:chkconfig mysql on