转--linux下安装mysql

 

redhat enterprise6.0

mysql-5.1.50-linux-i686-glibc23.tar.gz免编译包

# tar -zvxf mysql-max-5.1.30-linux-i686-glibc23.tar.gz

# mv mysql-max-5.1.30-linux-i686-glibc23 /usr/local/mysql

# cp /usr/local/mysql/support-files/my-medium.cnf /etc/my.cnf

# groupadd mysql

# useradd -g mysql mysql

# chown -R root /usr/local/mysql

# chgrp -R mysql /usr/local/mysql

# chown -R mysql /usr/local/mysql/data

# cd /usr/local/mysql

修改/etc/my.cnf ，打开[client] 中的password，设置密码

# scripts/mysql_install_db --user=mysql

如果有错误发生，执行 # sed -i 's/log-bin=mysql-bin/

#log-bin=mysql-bin/g' /etc/my.cnf

# sed -i 's/binlog_format=mixed/

#binlog_format=mixed/g' /etc/my.cnf

# sed -i 's/skip-locking/skip-locking/nmax_connections = 1000/nwait_timeout = 5/g' /etc/my.cnf

重新初始化

# scripts/mysql_install_db --user=mysql

# cp support-files/mysql.server /etc/rc.d/init.d/mysqld

# chmod 755 /etc/rc.d/init.d/mysqld

# chkconfig --add mysqld

# chkconfig mysqld on

# service mysqld start

# netstat -nat

mysql的server默认在3306端口listen，查看是否打开端口

然后在/usr/local/mysql下执行：

# bin/mysqladmin -u root password mysql（因为我在/etc/my.cnf里设置的client密码是mysqld）

然后出现错误：

先将刚才设置的密码注销掉（文件中那一行前加#）

#/etc/init.d/mysqld stop

#bin/mysqld_safe --skip-grant-tables & 1Fhr2O q9^+`v~0

ra

下图在需要输入

上图在需要输入password的时候，回车就可以

 

然后重新启动