mysql-5.6.41-linux-glibc2.12-x86_64.tar.gz
tar -xzvf mysql
mv mysql /usr/local/mysql
cd mysql
groupadd mysql
useradd -r -g mysql -s /bin/false mysql
chown -R mysql:mysql mysql
chmod 750 mysql
yum -y install autoconf
yum install libaio
cd mysql
./scripts/mysql_install_db --user=mysql
bin/mysqld --initialize --user=mysql
bin/mysqld_safe --user=mysql &
chown -R root:root ./
cp support-files/mysql.server /etc/init.d/mysql
chmod +x /etc/init.d/mysql
更改 /usr/local/mysql/my.cnf 和 /etc/my.cnf
--------------------------------
[mysqld_safe]
#log-error=/var/log/mariadb/mariadb.log
#pid-file=/var/run/mariadb/mariadb.pid
log-error=/usr/local/mysql/mysqld_safe/mariadb.log
pid-file=/usr/local/mysql/mysqld_safe/mariadb.pid
--------------------------------------------------
必须创建/usr/local/mysql/mysqld_safe/mariadb.log
service mysql start
service mysql restart
service mysql stop
--------------------------
service mysql status
yum install lsof
lsof -i:3306
ln -s /usr/local/mysql/bin/mysql /usr/bin
mysql -h localhost -u root -p
123456
show databases;
iptables -A INPUT -ptcp --dport 3306 -j ACCEPT
远程访问:所有主机均可密码访问,如果需要本机localhost访问,需要通过navicat复制一条刚才的数据,insert进去,把修改后的数据%再换成localhost
mysql -u root -p
use mysql;
update user set host = '%' where user = 'root' and host='localhost';
select host,user from user;
重启mysql,service mysql stop,service mysql start
service mysql restart
yum install -y unzip zip
https://dev.mysql.com/doc/refman/5.7/en/binary-installation.html
shell> groupadd mysql shell> useradd -r -g mysql -s /bin/false mysql shell> cd /usr/local shell> tar zxvf /path/to/mysql-VERSION-OS.tar.gz shell> ln -s full-path-to-mysql-VERSION-OS mysql shell> cd mysql shell> mkdir mysql-files shell> chown mysql:mysql mysql-files shell> chmod 750 mysql-files shell> bin/mysqld --initialize --user=mysql shell> bin/mysql_ssl_rsa_setup shell> bin/mysqld_safe --user=mysql & # Next command is optional shell> cp support-files/mysql.server /etc/init.d/mysql.server
相关推荐
Linux下安装mysql日志,算是一个比较详细的教程。
linux安装mysql 手把手教你linux下安装mysql数据库 超简单完成mysql安装 contos下安装mysql超详细步骤
超级无敌web服务器 linux+apache+tomcat+mysql+jsp+php 整合安装 自己的安装过程,以前发表在新浪博客,现在换地盘了转过来... 自我感觉写得还是不错滴.. 在安装过程更是学到了很多东西 做好这个项目以后linux...
html+css+js+php+mysql+linux帮助手册,完整版W3CSchool线下教程chm
Linux+Nginx+Mysql+Php安装教程
Linux下Apache+PHP+Mysql安装与配置
Java+mysql+Linux面试题
Linux 下 JDK + Tomcat + MySQL + JDBC 安装与配置
LAMP(Linux+Apache+Mysql+php)安装配置;刚接触linux环境安装,会徘徊源码安装还是yum安装好; yum安装软件方便些;分安装篇和配置篇、测试篇
Linux下的nginx+mysql+Php安装
Linux+Apache+Mysql+PHP典型安装配置
Ubuntu下LAMP(linux+apache+mysql+php)环境的配置与安装.pdf
mysql+apache+php在Linux整合安装配置
从0开始 学习PHP+MySQL+Linux 学习路线
linux下的WWW服务器的详细配置和有关参数解释,以及应用软件的安装。
主要是在linux上安装mysql+apache+php+wordpress,linux,suselinux,ubuntu都可以,笔记很详细,对于新手非常有帮助
PHP+MYSQL+LINUX在校园网中的应用.pdf
php+apache+mysql 在linux下的安装手册,按照这个步骤,绝对没问题,
centos 安装mysql5.7 Linux下centos安装mysql5.7 超详细步骤,带你手把手安装mysql
php+mysql+apache+linux环境搭建分享.pdf