mysql环境配置及常用命令

1、查询myql安装目录

• 查看mysql 进程 ps -ef|grep mysqld

• whereis mysql

2、修改/etc/my.cnf文件

• 大小写设置为不敏感，增加参数 lower_case_table_names=1

[root@dev-db1 etc]# more my.cnf[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sock# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0# Settings user and group are ignored when systemd is used.# If you need to run mysqld under a different user or group,# customize your systemd unit file for mariadb according to the# instructions in http://fedoraproject.org/wiki/Systemd[mysqld_safe]log-error=/var/log/mariadb/mariadb.logpid-file=/var/run/mariadb/mariadb.pid## include all files from the config directory#!includedir /etc/my.cnf.d[root@dev-db1 etc]# vi my.cnf[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sock# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0# Settings user and group are ignored when systemd is used.# If you need to run mysqld under a different user or group,# customize your systemd unit file for mariadb according to the# instructions in http://fedoraproject.org/wiki/Systemd[mysqld_safe]log-error=/var/log/mariadb/mariadb.logpid-file=/var/run/mariadb/mariadb.pid## include all files from the config directory#!includedir /etc/my.cnf.dlower_case_table_names=1

3、查看mysql服务启动状态命令

执行命令： status mysqld.service

4、查看服务进程

查看服务进程：ps aux|grep mysqld >[root@dev-db1 mysql]# pidof mysqld  4901  >systemctl list-unit-files|grep mysqld.service mysqld.service   static

5、环境变量配置

• .bash_profile

[mysql@dev-db1 ~]$ vi .bash_profile # Get the aliases and functionsif [ -f ~/.bashrc ]; then        . ~/.bashrcfi# User specific environment and startup programsPATH=$PATH:$HOME/.local/bin:$HOME/bin:/data/mysql/bin:/data/mysql/libexport PATH~