linux下mysql的安装过程.docxVIP

最近在linux安装了mysql，根据网上收集的资料和个人的操作过程，大概做了个整理，以便以后进行参考回顾。?1、下载mysql-5.1.36.tar.gz，并且解压.?tar -xzvf mysql-5.1.36.tar.gz?2、添加mysql组，新建mysql用户?groupadd mysql?useradd -g mysql mysql?3.进入解压后的目录下，进行编译安装?./configure --prefix=/usr/local/mysql --with-charset=utf8 --with-extra-charsets=all --enable-assembler --enable-thread-safe-client --with-big-tables --with-readline --with-ssl --with-embedded-server --with-plugins=all?4.make?5.make install?6.安装完成后，mysql的安装目录为prefix中指定的/usr/local/mysql?7.进入安装目录,复制配置文件?cp support-files/my-large.cnf /etc/my.cnf?8.更新/usr/local/mysql文件夹的所有者及用户组?cd /usr/local/mysql/?chown -R mysql .?chgrp -R mysql .?9.配置mysql随服务器启动的服务?cp /home/mysql-5.1.36/support-files/mysql.server /etc/init.d/mysqld?chmod 755 /etc/init.d/mysqld?chkconfig --add mysqld?10.初始化mysql?bin/mysql_install_db --user=mysql?11.启动mysql服务?方法1:service mysqld start?方法2:/usr/local/mysql/bin/mysqld_safe --user=mysql ?12.关闭MySQL服务?/usr/local/mysql/bin/mysqladmin -u root -p? shutdown //关闭MySQL?13.查看mysql服务端口状态（3306）?? netstat -atln?14.mysql默认是没有密码的,设置登录mysql的新密码?/usr/local/mysql/bin/mysqladmin -u root -password xxx?15.登录msyql?/usr/local/mysql/bin/mysql -u root -p?16.添加mysql的用户?登录mysql,添加mysql用户?grant 权限 on 数据库名.表名用户@登录主机 identified by 用户密码;?添加testA，容许localhost登录，密码为123456?添加testB，容许远程登录，密码为123456?添加testC，容许远程登录，密码为123456?GRANT ALL PRIVILEGES ON *.* TO testA@localhost IDENTIFIED BY 123456 WITH GRANT OPTION;?GRANT ALL PRIVILEGES ON *.* TO testB@% IDENTIFIED BY 123456 WITH GRANT OPTION;?grant select,update,insert, on *.* to? testC@% identified by 123456；?17.测试一下，在windows下使用mysql客户端软件指定IP地址、用户名、密码测试连接到linux下的mysql。?18.完毕。?附：?1. ./configure?--prefix=/usr/local/mysql //MySQL安装目录?--datadir=/mydata //数据库存放目录?--with-charset=utf8 //使用UTF8格式?--with-extra-charsets=complex //安装所有的扩展字符集?--enable-thread-safe-client //启用客户端安全线程?--with-big-tables //启用大表?--with-ssl //使用SSL加密?--with-embedded-server //编译成embedded MySQL library (libmysqld.a),?--enable-local-infile //允许从本地导入数据?--enable-assembler //汇编x86的普通操作符，可以提高性能?--wit