ubuntn下的mysql安装 （附详细命令）

#解压

			tar -zxvf mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz

			#复制解压后的mysql目录

			cp -r mysql-5.6.33-linux-glibc2.5-x86_64 /usr/local/mysql

#添加用户组

			groupadd mysql

			#添加用户mysql 到用户组mysql

			useradd -g mysql mysql

cd /usr/local/mysql/<br>mkdir ./data/mysql

			chown -R mysql:mysql ./

			./scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysql/data/mysql

			cp support-files/mysql.server /etc/init.d/mysqld

			chmod 755 /etc/init.d/mysqld

			cp support-files/my-default.cnf /etc/my.cnf

			 

			#修改启动脚本

			vi /etc/init.d/mysqld

			 

			#修改项：

			basedir=/usr/local/mysql/

			datadir=/usr/local/mysql/data/mysql

			 

			#启动服务

			service mysqld start

			 

			#测试连接

			./mysql/bin/mysql -uroot

			 

			#加入环境变量，编辑 /etc/profile，这样可以在任何地方用mysql命令了

			export PATH=$PATH:/usr/local/mysql//bin<br>source /etc/profile

			 

			 

			#启动mysql

			service mysqld start

			#关闭mysql

			service mysqld stop

			#查看运行状态

			service mysqld status

use mysql;
select 'host' from user where user='root'; 
update user set host = '%' where user ='root';
flush privileges;