centos安装mysql5.5.21.docx

#rpm –qa|grep–imysql查看已安装的mysql版本如果有已存在的mysql版本，则删除 #rpm –e –nodeps查看到的mysql的文件名先将文件拷贝到 /usr/local/src下，进入src[root@localhost ~]# cd /usr/local/src[root@localhostsrc]# rpm -ivh MySQL-server-5.5.21-1.linux2.6.x86_64.rpm安装后会出现以下信息，提示不要忘记设计root用户的密码以及其他信息之后会出现[root@localhostsrc]# 输入[root@localhostsrc]# 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的情况：selectuser,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：重启：servicemysqld restart?重启服务要在[root@localhost ~]#重启。需要先退出mysql?9：退出mysql：exit;