suse rpm安装mysql_LINUX SUSE MYSQL RPM安装

参考博文

https://blog.csdn.net/skylinethj/article/details/38856295

http://xinchibaobei.blog.163.com/blog/static/12639250920134954835786/

1、准备工作

从MySQL官网上分别下载mysql服务器端于客户端包：

MySQL-server-5.5.59-1.sles11.x86_64.rpm

MySQL-client-5.5.59-1.sles11.x86_64.rpm

下载地址

https://dev.mysql.com/downloads/mysql/5.5.html#downloads

2、查看并删除本机mysql进程信息

rpm -qa | grep  -i mysql

*如果安装了mysql则会出现mysql相关的服务跟依赖

卸载服务及依赖命令如下

rpm -ev  服务名

3、安装mysql

rpm -ivh MySQL-server-5.5.59-1.sles11.x86_64.rpm

rpm -ivh MySQL-client-5.5.59-1.sles11.x86_64.rpm

4、修改配置文件

cd /usr/share

vim my-medium.cnf

/*************修改内容如下**************/

[client]

password = root

port = 3306

socket = /data/mysql/mysql.sock

default-character-set=utf8

[mysqld]

port = 3306

socket = /data/mysql/mysql.sock

skip-external-locking

key_buffer_size = 16M

max_allowed_packet = 1M

table_open_cache = 64

sort_buffer_size = 512K

net_buffer_length = 8K

read_buffer_size = 256K

read_rnd_buffer_size = 512K

myisam_sort_buffer_size = 8M

character_set_server=utf8

collation-server=utf8_general_ci

lower_case_table_names=1

character_set_client=utf8

max_connections=1000

[mysql]

default-character-set = utf8

no-auto-rehash

/***************************/

5、重启mysql

cd /usr/bin

mysql_install_db

cd /etc/init.d

./mysql restart

6、登陆mysql

cd /usr/bin

mysql -u root -p

password:第一次登陆直接回车

7、修改root用户密码*一定要修改并记住密码，不然下次登陆不进来

show databases;

use mysql;

update user set password=password('root') where user='root';

8、重启mysql并登陆验证修改密码是否已经生效。

生效则说明已经安装成功。