Linux 6.7 安装 MySQL 8.0.16
时间：2021-07-01 10:21:17
帮助过：17人阅读
mysql
> show databases;
2 +--------------------+
3 | Database |
4 +--------------------+
5 | information_schema
|
6 | mysql
|
7 | performance_schema
|
8 | sys
|
9 +--------------------+
10 4 rows
in set (
0.00 sec)
11
12 mysql
> show tables;
13 ERROR
1046 (3D000): No
database selected
14 mysql
> use mysql;
15 Reading
table information
for completion
of table and column names
16 You can turn
off this feature
to get a quicker startup
with -A
17
18 Database changed
19 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 Resources | Location |
|---|
| 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
