20140318更新
# rpm -qa | grep -i mysql
yum erase mysql-5.1.69-1.el6_4.x86_64 mysql-devel-5.1.69-1.el6_4.x86_64 mysql-server-5.1.69-1.el6_4.x86_64 mysql-libs-5.1.69-1.el6_4.x86_64
wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-server-5.6.16-1.el6.x86_64.rpm wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-client-5.6.16-1.el6.x86_64.rpm wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-devel-5.6.16-1.el6.x86_64.rpm wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-shared-5.6.16-1.el6.x86_64.rpm
yum install MySQL-server-5.6.16-1.el6.x86_64.rpm
yum install MySQL-client-5.6.16-1.el6.x86_64.rpm
yum install MySQL-devel-5.6.16-1.el6.x86_64.rpm
yum install MySQL-shared-5.6.16-1.el6.x86_64.rpm
# cat /root/.mysql_secret
# The random password set for the root user at Fri Oct 11 15:43:09 2013 (local time): eDpfy22r
# service mysql start
# mysql -uroot -p
mysql> set password for 'root'@'localhost'=password('xxxxxx');
mysql> use mysql;
Database changed
mysql> select host, user, password from user;
+-------------------------------+------+-------------------------------------------+
| host | user | password |
+-------------------------------+------+-------------------------------------------+
| localhost | root | *D3F8362A5CC757B308222F6CF971CC5407185638 |
| terminal-manage.cxdnext.co.jp | root | *D13EFCDE1766FB275BEC1B94639DF8E0305861A8 |
| 127.0.0.1 | root | *D13EFCDE1766FB275BEC1B94639DF8E0305861A8 |
| ::1 | root | *D13EFCDE1766FB275BEC1B94639DF8E0305861A8 |
+-------------------------------+------+-------------------------------------------+
4 rows in set (0.00 sec)
mysql>
mysql> use mysql;
Database changed
mysql> select host, user, password from user;
+-------------------------------+------+-------------------------------------------+
| host | user | password |
+-------------------------------+------+-------------------------------------------+
| localhost | root | *D3F8362A5CC757B308222F6CF971CC5407185638 |
| terminal-manage.cxdnext.co.jp | root | *D13EFCDE1766FB275BEC1B94639DF8E0305861A8 |
| 127.0.0.1 | root | *D13EFCDE1766FB275BEC1B94639DF8E0305861A8 |
| ::1 | root | *D13EFCDE1766FB275BEC1B94639DF8E0305861A8 |
+-------------------------------+------+-------------------------------------------+
4 rows in set (0.00 sec)
mysql>
0 件のコメント:
コメントを投稿