centos安装mysql5.5.21.docx

#rpm qa|grep i mysql 查看已安装的mysql版本如果有已存在的mysql版本，则删除 #rpm e nodeps 查看到的mysql的文件名先将文件拷贝到 /usr/local/src下，进入srcrootlocalhost # cd /usr/local/srcrootlocalhost src# rpm -ivh MySQL-server-5.5.21-1.linux2.6.x86_64.rpm安装后会出现以下信息，提示不要忘记设计root用户的密码以及其他信息之后会出现rootlocalhost src# 输入rootlocalhost src# rpm -ivh MySQL-server-5.5.21-1.linux2.6.x86_64.rpm查看是否存在安装的mysql文件之后查看mysql的服务是否启动，#netstat -nat默认的端口是3306，如果没有启动的话，就打开服务#service mysql start 启动mysql 服务启动服务后，进入mysql进入mysql数据库后，use mysql然后查看一下root的情况 ：select user,password form user;修改密码：update user set password= password (newpassword)where user=root and host=root or host=localhost;最好是提交commint一下。然后再查看一下用户至此，mysql是安装成功了的。参考资料：7：ip访问then: select host, user from user;mysql select host, user from user;+-+-+| host | user |+-+-+| % | test | 127.0.0.1 | root | localhost | | localhost | root | localhost | test | localhost.localdomain | | localhost.localdomain | root |+-+-+7 rows in set (0.00 sec)然后修改一个root用户的host为你的ip地址update user u set u.host = your_ipaddress where u.user = root and u.host = localhost;update user u set u.host = 192.168.1.42 where u.user = root and u.host = localhost;mysql select host, user from user;+-+-+| host | user |+-+-+| % | test | 127.0.0.1 | root | 192.168.1.42 | root | localhost | test | localhost.localdomain | root |+-+-+5 rows in set (0.00 sec)8：重启： se