|
centos 6.2下 源码安装mysql 5.5.22
1. 安装mysql 相关依赖库（没有的话就安装，有就不用安装了）
通过 rpm -qa | grep name 的方式验证以下软件包是否已全部安装。 没有的话安装： yum安装： #yum install bison gcc gcc-c++ autoconf automake zlib* libxml* ncurses-devel libtool rpm –ivh 安装： 例如：rpm -ivh MySQL-devel-4.0.24-0.i386.rpm 2.安装cmake包 # wgethttp://www.cmake.org/files/v2.8/cmake-2.8.6.tar.gz # tar zxvf cmake-2.8.6.tar.gz # cd cmake-2.8.6/ # ./configure # gmake # gmake install
3.添加用户和创建数据库目录和权限设置 # group add mysql #useradd mysql –g mysql # mkdir -p /data/mysql # chown -R mysql:mysql /data/mysql
4.MYSQL 5.5.22安装 #cd /usr/local/src # wget http://down1.chinaunix.net/distfiles/mysql-5.5.22.tar.gz # tar zxvf mysql-5.5.22.tar.gz # cd mysql-5.5.22 # cmake-DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DSYSCONFDIR=/etc-DMYSQL_DATADIR=/mysql/data -DMYSQL_TCP_PORT=3306-DMYSQL_UNIX_ADDR=/tmp/mysqld.sock -DMYSQL_USER=mysql # gmake # gmake install
5.设置mysql配置文件 # cd /usr/local/mysql # cp ./support-files/my-huge.cnf/etc/my.cnf
5.1编辑/etc/my.cnf # vi /etc/my.cnf 在 [mysqld] 段增加 datadir = /data/mysql wait-timeout = 30 max_connections = 512 max_connect_errors = 10000000 default-storage-engine = MyISAM
在 [mysqld] 段修改 max_allowed_packet = 16M
[mysqld_safe]增加字段 log-error=/data/mysql/log/mysqld.log
6.初始化数据库 #cd /usr/local/mysql # 9 ./scripts/mysql_install_db --datadir=/data/mysql--basedir=/usr/local/mysql --defaults-file=/etc/my.cnf --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 --level 35 mysqld on
7.设置启动脚本变量 编辑 /etc/rc.d/init.d/mysqld # vi /etc/rc.d/init.d/mysqld basedir=/usr/local/mysql datadir=/data/mysql
8.设置变量环境 # echo"PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile（永久生效） # export PATH=$PATH:/usr/local/mysql/bin（当前生效） 或者 # . /etc/profile
9.启动服务 # service mysqld start
10.设置数据库管理员root密码 重新启动mysqld服务 # mysqladmin -u root password '123456' # service mysqld restart
查看mysql服务： [root@tata data]#netstat-npalt | grep 3306 tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 25051/mysqld 查看mysql进程 [root@tata data]#ps -ef | grep "mysql" root 24737 1 0 08:04 pts/1 00:00:00 /bin/sh/usr/local/mysql/bin/mysqld_safe --datadir=/data/mysql--pid-file=/data/mysql/tata.domain.pid mysql 25051 24737 0 08:04 pts/1 00:00:00 /usr/local/mysql/bin/mysqld--basedir=/usr/local/mysql --datadir=/data/mysql--plugin-dir=/usr/local/mysql/lib/plugin --user=mysql--log-error=/data/mysql/tata.domain.err --pid-file=/data/mysql/tata.domain.pid--socket=/tmp/mysqld.sock --port=3306 root 25130 2648 0 08:24 pts/1 00:00:00 mysql -u root -p root 25183 9149 0 08:34 pts/2 00:00:00 grep mysql 11.进入Mysql # mysql -u root -p 输入密码 mysql> show databases; +-----------------------+ | Database | +-----------------------+ | information_schema | | mysql | | #mysql50#mysql-5.5.22 | | performance_schema | | test | +-----------------------+ 5 rows in set (0.00 sec)
mysql> use mysql; Database changed mysql> show tables; +---------------------------+ | Tables_in_mysql | +---------------------------+ | columns_priv | ........
11.管理mysql ,建表，建库
显示mysql存储引擎 mysql>showengines;
编码方式更改 |