04_MySQL安装.doc

安装MySQL 1．下载MySQL 下载地址： /download/0008000/7159.shtml 2．上传到CentOS服务器 将RPM包上传至服务器，本例放在 /tmp 中 3．安装MySQL 在安装MySQL 5前先确认旧版本的mysql包已经被删除，如旧版本的MYSQL没有删除，新版本的MySQL可能无法进行安装。 # rpm -qa |grep MySQL 使用命令查看是否安装了旧版本的MYSQLMySQL-server-4.1.23-1.linux2.6 MySQL-client-4.1.21-1.linux2.6 MySQL-devel-4.1.25-1.linux2.6 MySQL-shared-4.1.25-1.linux2.6 如果存在使用如下命令进行删除。 # rpm –e MySQL-server-4.1.23-1.linux2.6 # rpm –e MySQL-client-4.1.21-1.linux2.6 # rpm –e MySQL-devel-4.1.25-1.linux2.6 # rpm –e MySQL-shared-4.1.25-1.linux2.6 安装MySQL #rpm –ivh MySQL-server-5.5.23-1.linux2.6.linux2.6.i386.rpm #rpm –ivh MySQL-client-5.5.23-1.linux2.6.linux2.6.i386.rpm 4．配置参数 查看MySQL服务状态 # service mysql status MySQL running (2344)[ OK ] 停止MySQL服务 # service mysql stop Shutting down MySQL.[ OK ] 启动MySQL服务 # service mysql start Starting MySQL.[ OK ] 验证MySQL服务 # mysql Welcome to the MySQL monitor. Commands end with ; or \g. Type help; or \h for help. Type \c to clear the current input statement. mysql /*出现mysql 的提示符，则说明MySQL安装成功。*/ 配置MySQL root访问密码 #mysqladmin -u root password root # mysql ERROR 1045 (28000): Access denied for user root@localhost (using password: NO) # mysql –p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Type help; or \h for help. Type \c to clear the current input statement. mysql 配置防火墙，开启MySQL远程访问端口 #/etc/init.d/iptables status Table: filter Chain INPUT (policy ACCEPT) num target prot opt source destination 1 RH-Firewall-1-INPUT all -- /0 /0 Chain FORWARD (policy ACCEPT) num target prot opt source destination 1 RH-Firewall-1-INPUT all -- /0 /0 Chain OUTPUT (policy ACCEPT) num target prot opt source destination Chain RH-Firewall-1-INPUT (2 references) num target prot opt source destination 1 ACCEPT all -- /0