mysql>show databases;2 +--------------------+
3 | Database |
4 +--------------------+
5 | information_schema |
6 | mysql |
7 | performance_schema |
8 | sys |
9 +--------------------+
10 4 rows in set (0.00sec)11
12 mysql>show tables;13 ERROR 1046 (3D000): No databaseselected14 mysql> usemysql;15 Reading table information for completion of table and columnnames16 You can turn off this feature to get a quicker startup with -A17
18 Databasechanged19 mysql>show tables;20 +---------------------------+
21 | Tables_in_mysql |
22 +---------------------------+
23 | columns_priv |
24 | component |
25 | db |
26 | default_roles |
27 | engine_cost |
28 | func |
29 | general_log |
30 | global_grants |
31 | gtid_executed |
32 | help_category |
33 | help_keyword |
34 | help_relation |
35 | help_topic |
36 | innodb_index_stats |
37 | innodb_table_stats |
38 | password_history |
39 | plugin |
40 | procs_priv |
41 | proxies_priv |
42 | role_edges |
43 | server_cost |
44 | servers |
45 | slave_master_info |
46 | slave_relay_log_info |
47 | slave_worker_info |
48 | slow_log |
49 | tables_priv |
50 | time_zone |
51 | time_zone_leap_second |
52 | time_zone_name |
53 | time_zone_transition |
54 | time_zone_transition_type |
55 | user |
56 +---------------------------+
57 33 rows in set (0.00 sec)
MySQL Installation Layout for Linux RPM Packages from the MySQL Developer Zone
Files or ResourcesLocation
Client programs and scripts
/usr/bin
mysqld server
/usr/sbin
Configuration file
/etc/my.cnf
Data directory
/var/lib/mysql
Error log file
For RHEL, Oracle Linux, CentOS or Fedora platforms: /var/log/mysqld.log
For SLES: /var/log/mysql/mysqld.log
Value of secure_file_priv
/var/lib/mysql-files
System V init script
For RHEL, Oracle Linux, CentOS or Fedora platforms: /etc/init.d/mysqld
For SLES: /etc/init.d/mysql
Systemd service
For RHEL, Oracle Linux, CentOS or Fedora platforms: mysqld
For SLES: mysql
Pid file
/var/run/mysql/mysqld.pid
Socket
/var/lib/mysql/mysql.sock
Keyring directory
/var/lib/mysql-keyring
Unix manual pages
/usr/share/man
Include (header) files
/usr/include/mysql
Libraries
/usr/lib/mysql
Miscellaneous support files (for example, error messages, and character set files)
/usr/share/mysql
Linux 6.7 安装 MySQL 8.0.16
标签:sage ack bit pac usr sources current ODB page
本条技术文章来源于互联网,如果无意侵犯您的权益请点击此处反馈版权投诉
本文系统来源:https://www.cnblogs.com/coreloving/p/10790391.html