[root@xiaoluo ~]# yum list | grep mysql

[root@xiaoluo ~]# rpm -qi mysql-server

[root@xiaoluo ~]# service mysqld start

初始化 MySQL 数据库： WARNING: The host 'xiaoluo' could not be looked up with resolveip.

This probably means that your libc libraries are not 100 % compatible

with this binary MySQL version. The MySQL daemon, mysqld, should work

normally with the exception that host name resolving will not work.

This means that you should use IP addresses instead of hostnames

when specifying MySQL privileges !

Installing MySQL system tables...

OK

Filling help tables...

OK

To start mysqld at boot time you have to copy

support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !

To do so, start the server, then issue the following commands:

/usr/bin/mysqladmin -u root password 'new-password'

/usr/bin/mysqladmin -u root -h xiaoluo password 'new-password'

Alternatively you can run:

/usr/bin/mysql_secure_installation

which will also give you the option of removing the test

databases and anonymous user created by default.  This is

strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:

cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl

cd /usr/mysql-test ; perl mysql-test-run.pl

Please report any problems with the /usr/bin/mysqlbug script!

                                                           [确定]

正在启动 mysqld：                                            [确定]

[root@xiaoluo ~]# service mysqld restart

停止 mysqld：                                             [确定]

正在启动 mysqld：                                          [确定]

[root@xiaoluo ~]# chkconfig --list | grep mysqld

mysqld             0:关闭    1:关闭    2:关闭    3:关闭    4:关闭    5:关闭    6:关闭

[root@xiaoluo ~]# chkconfig mysqld on

[root@xiaoluo ~]# chkconfig --list | grep mysql

mysqld             0:关闭    1:关闭    2:启用    3:启用    4:启用    5:启用    6:关闭

/usr/bin/mysqladmin -u root password 'new-password'　　// 为root账号设置密码

[root@xiaoluo ~]# mysqladmin -u root password 'root'　　// 通过该命令给root账号设置密码为 root

解决远程连接mysql错误1130

远程连接Mysql服务器的数据库，错误代码是1130，ERROR 1130: Host xxx.xxx.xxx.xxx  is not allowed to connect to this MySQL server  
猜想是无法给远程连接的用户权限问题。 
这样子操作mysql库，即可解决。 
 
在本机登入mysql后，更改 “mysql” 数据库里的 “user” 表里的 “host” 项，从”localhost”改称'%'即可 
mysql -u root -p  
mysql;use mysql;  
mysql;select 'host' from user where user='root';  
mysql;update user set host = '%' where user ='root';  
mysql;flush privileges;  
mysql;select 'host'   from user where user='root'; 
 
 
第一句：以权限用户root登录  
第二句：选择mysql库  
第三句：查看mysql库中的user表的host值（即可进行连接访问的主机/IP名称）  
第四句：修改host值（以通配符%的内容增加主机/IP地址），当然也可以直接增加IP地址  
如果这步出错"ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY'" 由说明该记录有了，跳过这步
第五句：刷新MySQL的系统权限相关表  
第六句：再重新查看user表时，有修改。。