在linux上安装mysql rpm包
环境:linux:CentOS release 6.3mysql: 5.6.28-log MySQL Community Server (GPL)1.检查mysql rpm相关的包是否安装[root@mysqlmaster mysqlinstall]# rpm -qa | grep -i mysqlmysql-libs-5.1.61-4.el6.x86_64如果存在删除:
·
环境:
linux:CentOS release 6.3
mysql: 5.6.28-log MySQL Community Server (GPL)
1.检查mysql rpm相关的包是否安装
[root@mysqlmaster mysqlinstall]# rpm -qa | grep -i mysqlmysql-libs-5.1.61-4.el6.x86_64
如果存在删除:
[root@mysqlmaster mysqlinstall]# rpm -e mysql-libs-5.1.61-4.el6.x86_64
error: Failed dependencies:
libmysqlclient.so.16()(64bit) is needed by (installed) postfix-2:2.6.6-2.2.el6_1.x86_64
libmysqlclient.so.16(libmysqlclient_16)(64bit) is needed by (installed) postfix-2:2.6.6-2.2.el6_1.x86_64
mysql-libs is needed by (installed) postfix-2:2.6.6-2.2.el6_1.x86_64
忽略依赖包删除
[root@redis1 ~]# rpm -e --nodeps mysql-libs-5.1.61-4.el6.x86_64
或者删除依赖包
[root@mysqlmaster mysqlinstall]# yum -y remove mysql-libs
[root@mysqlmaster mysqlinstall]# rpm -qa | grep -i mysql
2.上传下载的安装包MySQL-5.6.28-1.el6.x86_64.rpm-bundle.tar
解压:
tar -xvf MySQL-5.6.28-1.el6.x86_64.rpm-bundle.tar
3.安装mysql服务端:
[root@mysqlmaster mysqlinstall]# rpm -ivh MySQL-server-5.6.28-1.el6.x86_64.rpm
warning: MySQL-server-5.6.28-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
libnuma.so.1()(64bit) is needed by MySQL-server-5.6.28-1.el6.x86_64
libnuma.so.1(libnuma_1.1)(64bit) is needed by MySQL-server-5.6.28-1.el6.x86_64
libnuma.so.1(libnuma_1.2)(64bit) is needed by MySQL-server-5.6.28-1.el6.x86_64
缺失依赖包
[root@mysqlmaster mysqlinstall]# yum install numactl
[root@mysqlmaster mysqlinstall]# rpm -ivh MySQL-server-5.6.28-1.el6.x86_64.rpm
warning: MySQL-server-5.6.28-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing... ########################################### [100%]
1:MySQL-server ########################################### [100%]
warning: user mysql does not exist - using root
warning: group mysql does not exist - using root
4.安装mysql 客户端
[root@mysqlmaster mysqlinstall]# rpm -ivh MySQL-client-5.6.28-1.el6.x86_64.rpm
warning: MySQL-client-5.6.28-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing... ########################################### [100%]
1:MySQL-client ########################################### [100%]
[root@mysqlmaster mysqlinstall]#
5.修改mysql配置文件
vi /etc/my.cnf
[mysqld]
# Options for mysqld process:
#skip-grant-tables
character_set_server=utf8
lower_case_table_names=1
max_connections=1000
datadir=/var/lib/mysql
[root@mysqlmaster mysql]# service mysql start
Starting MySQL SUCCESS!
6.登录修改root密码
查看root 用户的密码
[root@mysqlmaster mysql]# cat /root/.mysql_secret
# The random password set for the root user at Fri Dec 18 14:12:44 2015 (local time): g478da9wvEZniGqa
root用户登录
[root@mysqlmaster mysql]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.6.28
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> SET PASSWORD = PASSWORD('root001'); ---设置root用户密码
Query OK, 0 rows affected (0.01 sec)
mysql> exit
Bye
重新登录
[root@mysqlmaster mysql]# mysql -uroot -proot001
7.设置root用户支持远程登录:
mysql> select host,user,password from user;
+-------------+------+-------------------------------------------+
| host | user | password |
+-------------+------+-------------------------------------------+
| localhost | root | *F4368ED34678C82DC260E668501F2FA7201F34EB |
| mysqlmaster | root | *F7FFE6B0AA46DE21A8F0520CE00A0927B01B125D |
| 127.0.0.1 | root | *F7FFE6B0AA46DE21A8F0520CE00A0927B01B125D |
| ::1 | root | *F7FFE6B0AA46DE21A8F0520CE00A0927B01B125D |
+-------------+------+-------------------------------------------+
4 rows in set (0.00 sec)
mysql> update user set password=password('root001') where user='root';
Query OK, 3 rows affected (0.00 sec)
Rows matched: 4 Changed: 3 Warnings: 0
mysql> update user set host='%' where user='root' and host='localhost';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select host,user,password from user;
+-------------+------+-------------------------------------------+
| host | user | password |
+-------------+------+-------------------------------------------+
| % | root | *F4368ED34678C82DC260E668501F2FA7201F34EB |
| mysqlmaster | root | *F4368ED34678C82DC260E668501F2FA7201F34EB |
| 127.0.0.1 | root | *F4368ED34678C82DC260E668501F2FA7201F34EB |
| ::1 | root | *F4368ED34678C82DC260E668501F2FA7201F34EB |
+-------------+------+-------------------------------------------+
4 rows in set (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
更多推荐
已为社区贡献3条内容
所有评论(0)