[MySQL] 安装与环境配置

MySQL 安装与环境配置

一、centos MySQL安装配置

安装

# yum -y install gcc python-devel mysql mysql-devel mysql-server mariadb mariadb-server mariadb-devel

权限配置

# /usr/sbin/groupadd mysql
# /usr/sbin/useradd -g mysql mysql
# chown mysql.mysql /var/lib/mysql/  # 数据库默认路径

启动server

# systemctl start mariadb    #启动MariaDB
# systemctl stop mariadb     #停止MariaDB
# systemctl restart mariadb  #重启MariaDB
# systemctl enable mariadb   #设置开机启动
# ps -ef |grep mariadb
mysql    26079 25917  0 22:37 ?        00:00:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/run/mariadb/mariadb.pid --socket=/var/lib/mysql/mysql.sock
# netstat -tnlp |grep 3306
tcp        0      0 0.0.0.0:3306            0.0.0.0:*               LISTEN      26079/mysqld

设置密码

# mysqladmin -u root password '123456'  # 新增密码
# mysqladmin -u root -p'123456' password '12345678'   # 更改密码

启动mysql

# mysql -u root -p
Enter password:

MariaDB [(none)]> 

排错

1. OSError: mysql_config not found
=> 查看是否安装漏工具，比如mysql-devel
2. ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
=> 密码错误，忘记密码重设

忘记密码重设

# vim /etc/my.cnf
[mysqld]
skip-grant-tables   # 新增一行，跳过验证，更新密码后这句要去掉
# systemctl restart mariadb
# mysql
mysql> update user set password=password("你的新密码") where user="root";
mysql> flush privileges;
mysql> quit

二、 MAC MySQL 安装配置

下载安装

https://www.mysql.com/downloads
安装密码

shell配置

% vim .zshrc
PATH=$PATH:/usr/local/mysql/bin:/usr/local/mysql/support-files

启动server

% ps -A|grep mysql
% kill 
% sudo mysql.server start
% sudo mysql.server stop
% sudo mysql.server restart
% sudo mysql.server status

进入mysql

% mysql -u root -p