在RedHat 6.3下安装MySQL-server-5.6.13-1.el6.x86_64.rpm
首先下载下面三个文件:
MySQL-client-5.6.13-1.el6.x86_64.rpm
MySQL-devel-5.6.13-1.el6.x86_64.rpm
MySQL-server-5.6.13-1.el6.x86_64.rpm
然后使用root账号登陆,进行安装:
1. 安装server、devel、client:1. 安装server、devel、client:
rpm -ivh --replacefiles MySQL-s*.rpm
rpm -ivh --replacefiles MySQL-d*.rpm
rpm -ivh --replacefiles MySQL-c*.rpm
[root@localhost download]# rpm -ivh --replacefiles
MySQL-server-5.6.13-1.el6.x86_64.rpm Preparing... ###########################################
[100%] 1:MySQL-server ###########################################
[100%] [root@localhost download]# rpm -ivh --replacefiles
MySQL-client-5.6.13-1.el6.x86_64.rpm Preparing... ###########################################
[100%] 1:MySQL-client ###########################################
[100%] [root@localhost download]# rpm -ivh --replacefiles
MySQL-devel-5.6.13-1.el6.x86_64.rpm Preparing... ###########################################
[100%] 1:MySQL-devel ########################################### [100%]
要移除安装可以使用 rpm -e MySQL-server 、 rpm -e
MySQL-devel、MySQL-client即可;
2. 初始化数据库:
/usr/bin/mysql_install_db
3. 启动mysql服务:
service mysql start
使用命令ps -ef | grep mysql 查看mysql进程:
[root@localhost ~]# ps -ef | grep
mysql root 26047 1 0 18:14
pts/12 00:00:00 /bin/sh /usr/bin/mysqld_safe
--datadir=/var/lib/mysql
--pid-file=/var/lib/mysql/localhost.localdomain.pid mysql 26227
26047 0 18:14 pts/12 00:00:01
/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql
--plugin-dir=/usr/lib64/mysql/plugin --user=mysql
--log-error=/var/log/mysqld.log
--pid-file=/var/lib/mysql/localhost.localdomain.pid
--socket=/var/lib/mysql/mysql.sock root 26545
24726 0 18:27 pts/8 00:00:00 grep mysql
4.第一次登陆设置root密码:
首先查看 cat /root/.mysql_secret
root@localhost ~]# cat
/root/.mysql_secret # The random password set for the root user at Fri Aug 30 15:57:18
2013 (local time): fMYcarvB
然后命令行:mysql -u root -p ,然后输入上面的密码即可:
[root@localhost ~]# mysql -u root
-p Enter password: Welcome to the MySQL monitor. Commands end with ;
or \g. Your MySQL connection id is
5 Server version: 5.6.13 MySQL Community Server
(GPL) Copyright (c) 2000, 2013, 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.
设置root密码:
mysql> use mysql Database changed mysql> update user set password=password('root') where
user='root'; Query OK, 0 rows affected (0.15
sec) Rows matched: 5 Changed: 0 Warnings: 0 mysql> flush
privileges; Query OK, 0 rows affected (0.00 sec)
退出,重新登陆即可使用新的密码登陆;
5. 设置远程登陆:
使用root登陆到mysql后
mysql> update user set host='%' where
user='root'; ERROR 1062 (23000): Duplicate entry '%-root' for key
'PRIMARY' mysql> select host,user from
user; +-----------------------+------+ | host | user
| +-----------------------+------+ | % | root
| | 127.0.0.1 | root
| | 192.168.128.142 | root
| | ::1 | root
| | localhost.localdomain | root
| +-----------------------+------+ 5 rows in set (0.00 sec)
然后:
mysql> grant all privileges on *.* to 'root'@'%' with grant
option; Query OK, 0 rows affected (0.08
sec) mysql> exit Bye [root@localhost ~]# service mysql
restart Shutting down MySQL..
SUCCESS! Starting MySQL.. SUCCESS! 重启mysql即可远程登陆。