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

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/data4、创建用户和用户组与赋予数据存放目录权限# groupadd mysql# useradd -g mysql mysqlchown -R mysql:mysql /local/home/mysql/chown -R mysql:mysql /local/home/data/6、下载解压mysql7、编译mysql- 5.5.22cmake -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.txtroothost mysql-5.5.22# make ；make install8、初始化数据库rootlocalhost mysql-5.5.22# scripts/mysql_install_db -user=mysql -basedir=/local/home/mysql -datadir=/local/home/data9、设置mysqld的配置文件与开机启动# cp support-files/f /etc/f# cp support-files/mysql.server /etc/init.d/mysql# chmod 755 /etc/init.d/mysql# chkconfig -add mysql# chkconfig mysql on# cp support-files/f /etc/f10、启动mysql服务rootlocalhost mysql-5.5.22# /etc/init.d/mysqld start11、启动完成之后用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-password13、登入mysqlrootlocalhost mysql-5.5.22#/opt/mysql/mysql_dir/bin/mysql -u root -p14、删除本机匿名连接的空密码帐号mysqluse mysql; /选择默认数据库mysqlmysqlupdate user set password=root123 where user = ;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;17、设置MySQL远程连接数据库服务器设置# /mysql -u root -p /进入数据库mysqluse mysqlmysqlselect user,password,host from user;mysqlupdate user set host = 192.168.% where user = ;mysqlgrant all privileges on *.* to root% identified by root123;/给以rootip登录的远程连接赋予权限,能够连接数据库。远程无法连接的常见问题原因。并把远程登录用户的密码设置为rootmysql flush privileges;mysqlquit18、其他问题安装好MYSQL后启动数据库出错rootlocalhost mysql# service mysqld startStarting MySQL.Manager of pid-file quit without updating f失败1、在 f 中增加了 在server下面# The MySQL servermysqldport = 3306socket = /var/mysql/mysql.sock添加下面一行datadir = /var/mysql/data和safe_mysqlderr-log = /v