Info
Name | Version | Home URL(Download HOme) | Install Path | Remark |
MySQL | 5.1.35 | http://dev.mysql.com/downloads/mysql/5.1.html#source | /usr/local/mysql |
Install
[root@wzhu ~]# groupadd mysql
[root@wzhu ~]# useradd -g mysql -m -d /usr/local/mysql -r mysql
[root@wzhu ~]# tar zxf mysql-5.1.35.tar.gz
[root@wzhu ~]# cd mysql-5.1.35
[root@wzhu mysql-5.1.35]# ./configure /
> --prefix=/usr/local/mysql/ /
> --enable-local-infile /
> --with-charset=utf8 /
> --with-extra-charsets=all /
> --with-system-type=centos /
> --with-machine-type=powerpc /
> --with-pthread /
> --with-unix-socket-path=/tmp/mysql.sock /
> --with-mysqld-user=mysql /
> --with-ssl /
> --with-mysqlmanager /
> --with-big-tables /
> --with-plugins=all
[root@wzhu mysql-5.1.35]# make
[root@wzhu mysql-5.1.35]# make install
[root@wzhu mysql-5.1.35]# cp support-files/my-medium.cnf /usr/local/mysql/my.cnf
[root@wzhu mysql-5.1.35]# cd /usr/local/mysql/
[root@wzhu mysql]# chmod -R 755 .
[root@wzhu mysql]# chown -R mysql.mysql .
[root@wzhu mysql]# bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var
[root@wzhu mysql]# chown -R root.mysql .
[root@wzhu mysql]# chown -R mysql.mysql var/
[root@wzhu ~]# useradd -g mysql -m -d /usr/local/mysql -r mysql
[root@wzhu ~]# tar zxf mysql-5.1.35.tar.gz
[root@wzhu ~]# cd mysql-5.1.35
[root@wzhu mysql-5.1.35]# ./configure /
> --prefix=/usr/local/mysql/ /
> --enable-local-infile /
> --with-charset=utf8 /
> --with-extra-charsets=all /
> --with-system-type=centos /
> --with-machine-type=powerpc /
> --with-pthread /
> --with-unix-socket-path=/tmp/mysql.sock /
> --with-mysqld-user=mysql /
> --with-ssl /
> --with-mysqlmanager /
> --with-big-tables /
> --with-plugins=all
[root@wzhu mysql-5.1.35]# make
[root@wzhu mysql-5.1.35]# make install
[root@wzhu mysql-5.1.35]# cp support-files/my-medium.cnf /usr/local/mysql/my.cnf
[root@wzhu mysql-5.1.35]# cd /usr/local/mysql/
[root@wzhu mysql]# chmod -R 755 .
[root@wzhu mysql]# chown -R mysql.mysql .
[root@wzhu mysql]# bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var
[root@wzhu mysql]# chown -R root.mysql .
[root@wzhu mysql]# chown -R mysql.mysql var/
Start MySQL
[root@wzhu mysql]# bin/mysqld_safe --defaults-file=/usr/local/mysql/my.cnf --user=mysql > /dev/null &
Set MySQL root password
[root@wzhu mysql]# /usr/local/mysql/bin/mysqladmin -u root password 123456
在安装的过程中出现问题及解决方式:
1. 一切操作完毕后 先把 $MYSQL_HOME/bin 放到$PATH下面去。
2. 当在终端输入mysql后有时会说/var/lib/mysql/mysql.sock 不存在,这是可以拷贝一个,也可以建立一个连接文件,指向/tmp/mysql.sock(mysql 启动后会产生/tmp/mysql.sock)
3. 要想让mysql随开机启动:
1) cp support-files/my-medium.cnf /etc/my.cnf
2) 注释掉 skip-locking 那一行
3) cp /usr/local/mysql/share/mysql/mysql.server /etc/init.d/mysqld
4) chkconfig --add mysqld
这样就把mysql加入到系统服务中,随系统开机而启动,并且就可以通过service mysqld start|stop|status|restart等进行管理,很是方便,就不用再到/usr/local/mysql5.0.45/bin/启动mysql了
或者是再/etc/rc.d/rc.local 下添加启动mysql语句即可。