Linux下 Mysql 5.5 源码安装手记.docxVIP

Linux下 Mysql 5.5 源码安装手记1、linux 主机名变更vi /etc/hostsvi /etc/sysconfig/network安装cmake安装ncurses-devel?如果需要则按照 gcc-c 和 bison2、创建mysql安装目录?# mkdir -p /local/home/mysql3、创建数据存放目录# mkdir -p /local/home/data?4、创建用户和用户组与赋予数据存放目录权限??# groupadd mysql??# useradd -g mysql mysql??chown -R mysql:mysql /local/home/mysql/?chown -R mysql:mysql /local/home/data/6、下载解压mysql7、编译mysql- 5.5.22?cmake -DCMAKE_INSTALL_PREFIX=/local/home/mysql \-DMYSQL_UNIX_ADDR=/var/mysql/mysql.sock \-DDEFAULT_CHARSET=utf8 \-DDEFAULT_COLLATION=utf8_general_ci \-DWITH_EXTRA_CHARSETS:STRING=all \-DWITH_MYISAM_STORAGE_ENGINE=1 \-DWITH_INNOBASE_STORAGE_ENGINE=1 \-DWITH_MEMORY_STORAGE_ENGINE=1 \-DWITH_READLINE=1 \-DENABLED_LOCAL_INFILE=1 \-DMYSQL_DATADIR=/local/home/data \-DMYSQL_USER=mysql \-DMYSQL_TCP_PORT=3306?#如何之前因为库文件安装不全,编译失败,安装完全库文件后,再次编译失败,则需要删除编译文件：rm -rf CMakeCache.txt?[root@host mysql-5.5.22]# make ；make install?8、初始化数据库?[root@localhost mysql-5.5.22]# scripts/mysql_install_db \?--user=mysql --basedir=/local/home/mysql \?--datadir=/local/home/data?9、设置mysqld的配置文件与开机启动??# cp support-files/my-medium.cnf /etc/my.cnf?# cp support-files/mysql.server /etc/init.d/mysql?# chmod 755 /etc/init.d/mysql?# chkconfig --add mysql??# chkconfig mysql on?# cp support-files/my-medium.cnf /etc/my.cnf?10、启动mysql服务??[root@localhost mysql-5.5.22]# /etc/init.d/mysqld start???11、启动完成之后用ps -ef |grep mysql 命令查看是否启动??12、为root帐户设置初始密码?# /opt/mysql/mysql_dir/bin/mysqladmin -u root password new-password?或者限制只能通过本机登陆?# /opt/mysql/mysql_dir/bin/mysqladmin -u root -h ‘hostname’ password new-password?13、登入mysql?[root@localhost mysql-5.5.22]#/opt/mysql/mysql_dir/bin/mysql -u root -p???14、删除本机匿名连接的空密码帐号?mysqluse mysql; //选择默认数据库mysql?mysqlupdate user set password=’root123’ where user = 127.0.0.1;?mysqldelete from user where password=;//不允许root密码为空?mysqlflush privileges;?mysqlquit?容许root用户是远程登录?15、防火墙允许访问3306iptables -I INPUT -p tcp --dport 3306 -j ACCEPTservice iptables save16、设置密码访问grant all privileges on *.* to root@% identified by abc123