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> select user,host,password from mysql.user;
+------+--------------+----------+
| user | host | password |
+------+--------------+----------+
| root | localhost | |
| root | eegooserver3 | |
| root | 127.0.0.1 | |
| | localhost | |
| | eegooserver3 | |
+------+--------------+----------+
5 rows in set (0.00 sec)
mysql> grant all on *.* to root@'%' identified by '123456';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> exit;
Bye
[root@eegooserver3 mysql]# cp support-files/mysql.server /etc/rc.d/init.d/mysqld
[root@eegooserver3 mysql]# chmod 700 /etc/init.d/mysqld
[root@eegooserver3 mysql]#chkconfig --add mysqld
[root@eegooserver3 mysql]# chkconfig --level 345 mysqld on
[root@eegooserver3 mysql]# chkconfig --list mysqld