mysql文件_mysql 文件位置 目录结构

0　　　　查看mysql进程    ps -ef|grep mysql

[root@localhost mysql]# ps -ef|grep mysql

root10626 7899 0 09:14 pts/0 00:00:00 mysql -u zt_dev -p

root22002 10757 0 14:32 pts/1 00:00:00 grep --color=auto mysql

mysql28782 1 0 3月04 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe --basedir=/usr

mysql28997 28782 3 3月04 ? 13:15:11 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock

查看文件安装路径 whereis mysql

[root@localhost mysql]# whereis mysql

mysql:/usr/bin/mysql /usr/lib64/mysql /usr/share/mysql /usr/share/man/man1/mysql.1.gz

查询运行文件所在路径 which mysql

[root@localhost mysql]# which mysql/usr/bin/mysql (运行文件是一堆乱码 看不懂 不要进去看了)

1　　　登录mysql后执行命令　show variables like '%dir%';

mysql> show variables like '%dir%';+-----------------------------------------+----------------------------+

| Variable_name | Value |

+-----------------------------------------+----------------------------+

| basedir | /usr/ |

| binlog_direct_non_transactional_updates | OFF |

| character_sets_dir | /usr/share/mysql/charsets/ |

| datadir | /var/lib/mysql/ |

| ignore_db_dirs | |

| innodb_data_home_dir | |

| innodb_log_group_home_dir | ./ |

| innodb_max_dirty_pages_pct | 75 |

| innodb_max_dirty_pages_pct_lwm | 0 |

| innodb_tmpdir | |

| innodb_undo_directory | . |

| lc_messages_dir | /usr/share/mysql/ |

| plugin_dir | /usr/lib64/mysql/plugin/ |

| slave_load_tmpdir | /tmp |

| tmpdir | /tmp |

+-----------------------------------------+----------------------------+

15 rows in set (0.00 sec)

2　　　　数据库目录：/var/lib/mysql/

配置文件my.cnf中 会 有一条配置 datadir=/var/lib/mysql  指定数据库目录位置

linux 和 navicate 显示的数据库目录一样 如下

3　　　　配置文件  /etc/my.cnf

[root@localhost mysql]# cat /etc/my.cnf

# For advice on how to change settings please see

# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html

[mysqld]

character_set_server=utf8

collation-server=utf8_general_ci

#

# Remove leading # andset to the amount of RAM forthe most important data

# cachein MySQL. Start at 70% of total RAM for dedicated server, else 10%.

# innodb_buffer_pool_size=128M

#

# Remove leading # to turn on a very important data integrity option: logging

# changes to the binary log between backups.

# log_bin

#

# Remove leading # toset options mainly useful forreporting servers.

# The server defaults are fasterfortransactions and fast SELECTs.

# Adjust sizesasneeded, experiment to find the optimal values.

# join_buffer_size=128M

# sort_buffer_size=2M

# read_rnd_buffer_size=2M

datadir=/var/lib/mysql mysql数据存储在这里

socket=/var/lib/mysql/mysql.sock

# Disabling symbolic-links isrecommended to prevent assorted security risks

symbolic-links=0# Recommendedinstandard MySQL setup

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

# Maximum lengthforGROUP_CONCAT

group_concat_max_len= -1

4　　　　mysql.sock的作用

对mysql.sock来说，其作用是程序与mysqlserver处于同一台机器，发起本地连接时可用

例如你无须定义连接host的具体IP地址，只要为空或localhost就可以。

在此种情况下，即使你改变mysql的外部port也是一样可能正常连接。

因为你在my.ini中或my.cnf中改变端口后，mysql.sock是随每一次 mysql server启动生成的。已经根据你在更改完my.cnf后重启mysql时重新生成了一次，信息已跟着变更。

那么对于外部连接，必须是要变更port才能连接的。

linux下安装mysql连接的时候经常回提示说找不到mysql.sock文件，解决办法很简单：

如果是新安装的mysql，提示找不到文件，就搜索下，指定正确的位置。

如果mysql.sock文件误删的话，就需要重启mysql服务，如果重启成功的话会在datadir目录下面生成mysql.sock 到时候指定即可。

5　　　　pid文件    /var/run/mysqld/mysqld.pid

当mysql实例启动时，会将自己的进程id写入一个文件中，

该文件即为pid文件。

6　　　　错误日志log-error文件 /var/log/mysqld.log

[root@localhost mysql]# tail -f /var/log/mysqld.log

Version:'5.6.44' socket: '/var/lib/mysql/mysql.sock' port: 3306MySQL Community Server (GPL)2020-03-04 10:26:03 28997 [Warning] IP address 'xxx.xxx.x.xxx'could not be resolved: Name or service not known2020-03-04 10:26:45 28997 [Warning] IP address 'xxx.xxx.x.xx' could not be resolved: Name or service not known