Linux主机下安装Mysql数据库

1.到官网下载源码包

2.相关安装命令

shell> groupadd mysql
shell> useradd -r -g mysql mysql
shell> cd /usr/local
shell> tar zxvf xx.tar.gz   //解压对应的压缩包

shell> ln -s 解压后的文件 mysql  //将解压的文件link到mysql文件夹
shell> cd mysql
shell> chown -R root .
shell> chown -R mysql data
shell> chgrp -R mysql .
shell> scripts/mysql_install_db --user=mysql
shell> bin/mysqld_safe --user=mysql &  //启动mysql服务

3.登陆mysql数据库

/app/mysql/bin/mysql --socket=/var/lib/mysql/mysql.sock -uroot -p

4.设置root密码

update user set password=password('kk123456~') where User='root';

5.创建用户并赋权

CREATE USER 'tdms'@'localhost' IDENTIFIED BY 'kk123456~';

grant all privileges on *.* to tdms@'%' identified by 'kk123456~';

flush privileges;

6.说明

  1.如果容许客户端访问mysql数据库的话，请在防火墙中增加端口3306或者关闭防火墙