linux下mysql安装方法

1. 将MySQL-server-5.5.27-1.rhel5.i386.rpm和MySQL-client-5.5.27-1.rhel5.i386.rpm上传到

root目录下

2. rpm -ivh MySQL-server-5.5.27-1.rhel5.i386.rpm rpm -ivh MySQL-client-5.5.27-1.rhel5.i386.rpm 3. 启动mysql

[root@cl ~]#service mysqld start 4. 设置mysql自动启动

[root@cl ~]# chkconfig mysql on

查看设置结果

[root@cl opt]# chkconfig --list mysql

5. 为用户设置密码

mysqladmin –u root password pigoss 6. 使用root登录mysql

mysql -u root –p Enter password: pigoss

7. Linux 下允许外部ip访问你到MySQL 数据库：

mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'pigoss' WITH GRANT OPTION; mysql>flush privileges;

8.使用pigoss自动发现mysql数据库