下载地址:
32bit:
64bit:
http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.16-linux-glibc2.5-x86_64.tar.gz
解压:
tar -zxvf mysql-5.1.60-linux-i686-glibc23.tar.gz
cp /mysql-5.5.15-linux2.6-i686 /usr/local
如果出现 '略过目录'提示, cp 后台加 -r (cp -r)
cd /usr/local
复制文件到安装目录:
mv mysql-5.5.15-linux2.6-i686 mysql
创建mysql用户和组:
# groupadd mysql
# useradd -g mysql mysql
给mysql相应目录权限:
# chgrp -R mysql /usr/local/mysql
# chown -R mysql /usr/local/mysql/data
安装初始化数据库:
scripts/mysql_install_db --datadir=/usr/local/mysql/data --user=mysql(安装目录下执行)
如果报错:Installing MySQL system tables..../bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
安装:yum install -y libaio
|
配置文件拷贝
cp support-files/my-medium.cnf /etc/my.cnf
cp support-files/mysql.server /etc/init.d/mysqld
bin/mysqld --user=mysql&
bin/mysqld_safe --user=mysql& (启动mysql,"&"表示在后台运行)
/etc/init.d/mysqld status 查看mysql状态
第一步:如何查看mysql是否安装成功。
一个方法是:去查看3306端口是否开启
命令:netstat -ntl 可以列出所有侦听的端口
其它:
mysql“Access denied for user 'root'@'localhost'”问题的解决 |
方法一: # /etc/init.d/mysqld stop # mysqld_safe --user=mysql --skip-grant-tables --skip-networking & # mysql -u root mysql mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root'; mysql> FLUSH PRIVILEGES; mysql> quit # /etc/init.d/mysql restart # mysql -uroot -p Enter password: <输入新设的密码newpassword> |