Curso de MariaDB Desde la Consola/iniciar el Servicio
< Curso de MariaDB Desde la Consola
Ir a la navegación
Ir a la búsqueda
Revisión del 19:11 22 oct 2015 de Rrc (discusión | contribuciones)
- Iniciar
- Asegurar la Instalación
- Entrar y Inspeccionar
- /etc/my.cnf.d/my-sql-clients.cnf
- /var/lib/mysql
- /usr/lib64/mysql/plugin
- #/var/log/mysqld/mysqld.log ! /var/log/mysqld/mysqld.log
- /var/run/mysqld/mysqld.pid
Iniciar
1 [root@Pridd etc]# systemctl start mysqld
2 [root@Pridd etc]# systemctl -l status mysqld
3 mysqld.service - MySQL database server
4 Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled)
5 Active: active (running) since Mon 2015-10-05 23:12:56 CDT; 8s ago
6 Process: 29766 ExecStartPost=/usr/sbin/mysqld-wait-ready $MAINPID (code=exited, status=0/SUCCESS)
7 Process: 29541 ExecStart=/usr/bin/mysqld_safe --nowatch (code=exited, status=0/SUCCESS)
8 Process: 29426 ExecStartPre=/usr/sbin/mysqld-prepare-db-dir (code=exited, status=0/SUCCESS)
9 Main PID: 29765 (mysqld)
10 CGroup: /system.slice/mysqld.service
11 └─29765 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mysqld/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock --port=3306
12
13 Oct 05 23:12:55 Pridd.LinuxCabal.org mysqld-prepare-db-dir[29426]: You can test the MariaDB daemon with mariadb-bench package
14 Oct 05 23:12:55 Pridd.LinuxCabal.org mysqld-prepare-db-dir[29426]: Please report any problems at http://mariadb.org/jira
15 Oct 05 23:12:55 Pridd.LinuxCabal.org mysqld-prepare-db-dir[29426]: The latest information about MariaDB is available at http://mariadb.org/.
16 Oct 05 23:12:55 Pridd.LinuxCabal.org mysqld-prepare-db-dir[29426]: You can find additional information about the MySQL part at:
17 Oct 05 23:12:55 Pridd.LinuxCabal.org mysqld-prepare-db-dir[29426]: http://dev.mysql.com
18 Oct 05 23:12:55 Pridd.LinuxCabal.org mysqld-prepare-db-dir[29426]: Support MariaDB development by buying support/new features from MariaDB
19 Oct 05 23:12:55 Pridd.LinuxCabal.org mysqld-prepare-db-dir[29426]: Corporation Ab. You can contact us about this at sales@mariadb.com.
20 Oct 05 23:12:55 Pridd.LinuxCabal.org mysqld_safe[29541]: 151005 23:12:55 mysqld_safe Logging to '/var/log/mysqld/mysqld.log'.
21 Oct 05 23:12:55 Pridd.LinuxCabal.org mysqld_safe[29541]: 151005 23:12:55 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
22 Oct 05 23:12:56 Pridd.LinuxCabal.org systemd[1]: Started MySQL database server.
Asegurar la Instalación
1 [root@Pridd etc]# mysql_secure_installation
2
3 NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
4 SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
5
6 In order to log into MariaDB to secure it, "we'll" need the current
7 password for the root user. If "you've" just installed MariaDB, and
8 you "haven't" set the root password yet, the password will be blank,
9 so you should just press enter here.
10
11 Enter current password for root (enter for none):
12 OK, successfully used password, moving on...
13
14 Setting the root password ensures that nobody can log into the MariaDB
15 root user without the proper authorisation.
16
17 Set root password? [Y/n] y
18 New password:
19 Re-enter new password:
20 Password updated successfully!
21 Reloading privilege tables..
22 ... Success!
23
24
25 By default, a MariaDB installation has an anonymous user, allowing anyone
26 to log into MariaDB without having to have a user account created for
27 them. This is intended only for testing, and to make the installation
28 go a bit smoother. You should remove them before moving into a
29 production environment.
30
31 Remove anonymous users? [Y/n] y
32 ... Success!
33
34 Normally, root should only be allowed to connect from 'localhost'. This
35 ensures that someone cannot guess at the root password from the network.
36
37 Disallow root login remotely? [Y/n] y
38 ... Success!
39
40 By default, MariaDB comes with a database named 'test' that anyone can
41 access. This is also intended only for testing, and should be removed
42 before moving into a production environment.
43
44 Remove test database and access to it? [Y/n] y
45 - Dropping test database...
46 ... Success!
47 - Removing privileges on test database...
48 ... Success!
49
50 Reloading the privilege tables will ensure that all changes made so far
51 will take effect immediately.
52
53 Reload privilege tables now? [Y/n] y
54 ... Success!
55
56 Cleaning up...
57
58 All done! If "you've" completed all of the above steps, your MariaDB
59 installation should now be secure.
60
61 Thanks for using MariaDB!
Entrar y Inspeccionar
1 [root@Pridd etc]# mysql -p
2 Enter password:
3 Welcome to the MariaDB monitor. Commands end with ; or \g.
4 Your MariaDB connection id is 12
5 Server version: 10.0.21-MariaDB Mageia MariaDB Server
6
7 Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
8
9 Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
10
11 MariaDB [(none)]> show databases;
12 +--------------------+
13 | Database |
14 +--------------------+
15 | information_schema |
16 | mysql |
17 | performance_schema |
18 +--------------------+
19 3 rows in set (0.00 sec)
20
21 MariaDB [(none)]> use mysql;
22 Database changed
23 MariaDB [mysql]> show tables;
24 +---------------------------+
25 | Tables_in_mysql |
26 +---------------------------+
27 | column_stats |
28 | columns_priv |
29 | db |
30 | event |
31 | func |
32 | general_log |
33 | gtid_slave_pos |
34 | help_category |
35 | help_keyword |
36 | help_relation |
37 | help_topic |
38 | host |
39 | index_stats |
40 | innodb_index_stats |
41 | innodb_table_stats |
42 | plugin |
43 | proc |
44 | procs_priv |
45 | proxies_priv |
46 | roles_mapping |
47 | servers |
48 | slow_log |
49 | table_stats |
50 | tables_priv |
51 | time_zone |
52 | time_zone_leap_second |
53 | time_zone_name |
54 | time_zone_transition |
55 | time_zone_transition_type |
56 | user |
57 +---------------------------+
58 30 rows in set (0.00 sec)
59
60 MariaDB [mysql]> select * from user;
61 +-----------+------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+--------+-----------------------+------------------+---------+
62 | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Create_user_priv | Event_priv | Trigger_priv | Create_tablespace_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | max_user_connections | plugin | authentication_string | password_expired | is_role |
63 +-----------+------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+--------+-----------------------+------------------+---------+
64 | localhost | root | *89EEF332E6A9A097B13F4FC946A41797C8992276 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | 0 | | | N | N |
65 | 127.0.0.1 | root | *89EEF332E6A9A097B13F4FC946A41797C8992276 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | 0 | | | N | N |
66 | ::1 | root | *89EEF332E6A9A097B13F4FC946A41797C8992276 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | 0 | | | N | N |
67 +-----------+------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+--------+-----------------------+------------------+---------+
68 3 rows in set (0.00 sec)
69
70 MariaDB [mysql]> select * from db;
71 Empty set (0.00 sec)
/var/lib/mysql
1 [rrc@Pridd ~]$ ls -al /var/lib/mysql/
2 total 86052
3 drwxr-xr-x 4 mysql mysql 4096 Oct 5 23:18 ./
4 drwxr-xr-x 46 root root 4096 Oct 5 04:02 ../
5 -rw-rw---- 1 mysql mysql 16384 Oct 5 23:12 aria_log.00000001
6 -rw-rw---- 1 mysql mysql 52 Oct 5 23:12 aria_log_control
7 -rw-rw---- 1 mysql mysql 77594624 Oct 5 23:12 ibdata1
8 -rw-rw---- 1 mysql mysql 5242880 Oct 5 23:12 ib_logfile0
9 -rw-rw---- 1 mysql mysql 5242880 Oct 5 23:12 ib_logfile1
10 -rw-rw---- 1 mysql mysql 0 Oct 5 23:12 multi-master.info
11 drwxr-xr-x 2 mysql mysql 4096 Oct 5 23:12 mysql/
12 srwxrwxrwx 1 mysql mysql 0 Oct 5 23:12 mysql.sock=
13 drwx------ 2 mysql mysql 4096 Oct 5 23:12 performance_schema/
14 -rw-rw---- 1 mysql mysql 0 Oct 5 23:12 sql_errors.log
15
16 [rrc@Pridd ~]$ ls -al /var/lib/mysql/mysql
17 total 1104
18 drwxr-xr-x 2 mysql mysql 4096 Oct 5 23:12 ./
19 drwxr-xr-x 4 mysql mysql 4096 Oct 5 23:18 ../
20 -rw-rw---- 1 mysql mysql 2110 Oct 5 23:12 columns_priv.frm
21 -rw-rw---- 1 mysql mysql 0 Oct 5 23:12 columns_priv.MYD
22 -rw-rw---- 1 mysql mysql 4096 Oct 5 23:12 columns_priv.MYI
23 -rw-rw---- 1 mysql mysql 3624 Oct 5 23:12 column_stats.frm
24 -rw-rw---- 1 mysql mysql 0 Oct 5 23:12 column_stats.MYD
25 -rw-rw---- 1 mysql mysql 4096 Oct 5 23:12 column_stats.MYI
26 -rw-rw---- 1 mysql mysql 2677 Oct 5 23:12 db.frm
27 -rw-rw---- 1 mysql mysql 1264 Oct 5 23:18 db.MYD
28 -rw-rw---- 1 mysql mysql 9216 Oct 5 23:18 db.MYI
29 -rw-rw---- 1 mysql mysql 3695 Oct 5 23:12 event.frm
30 -rw-rw---- 1 mysql mysql 0 Oct 5 23:12 event.MYD
31 -rw-rw---- 1 mysql mysql 2048 Oct 5 23:12 event.MYI
32 -rw-rw---- 1 mysql mysql 1582 Oct 5 23:12 func.frm
33 -rw-rw---- 1 mysql mysql 0 Oct 5 23:12 func.MYD
34 -rw-rw---- 1 mysql mysql 1024 Oct 5 23:12 func.MYI
35 -rw-rw---- 1 mysql mysql 35 Oct 5 23:12 general_log.CSM
36 -rw-rw---- 1 mysql mysql 0 Oct 5 23:12 general_log.CSV
37 -rw-rw---- 1 mysql mysql 804 Oct 5 23:12 general_log.frm
38 -rw-rw---- 1 mysql mysql 1024 Oct 5 23:12 gtid_slave_pos.frm
39 -rw-rw---- 1 mysql mysql 98304 Oct 5 23:12 gtid_slave_pos.ibd
40 -rw-rw---- 1 mysql mysql 1706 Oct 5 23:12 help_category.frm
41 -rw-rw---- 1 mysql mysql 1092 Oct 5 23:12 help_category.MYD
42 -rw-rw---- 1 mysql mysql 3072 Oct 5 23:12 help_category.MYI
43 -rw-rw---- 1 mysql mysql 1638 Oct 5 23:12 help_keyword.frm
44 -rw-rw---- 1 mysql mysql 91408 Oct 5 23:12 help_keyword.MYD
45 -rw-rw---- 1 mysql mysql 16384 Oct 5 23:12 help_keyword.MYI
46 -rw-rw---- 1 mysql mysql 970 Oct 5 23:12 help_relation.frm
47 -rw-rw---- 1 mysql mysql 9252 Oct 5 23:12 help_relation.MYD
48 -rw-rw---- 1 mysql mysql 19456 Oct 5 23:12 help_relation.MYI
49 -rw-rw---- 1 mysql mysql 1776 Oct 5 23:12 help_topic.frm
50 -rw-rw---- 1 mysql mysql 405476 Oct 5 23:12 help_topic.MYD
51 -rw-rw---- 1 mysql mysql 20480 Oct 5 23:12 help_topic.MYI
52 -rw-rw---- 1 mysql mysql 1897 Oct 5 23:12 host.frm
53 -rw-rw---- 1 mysql mysql 0 Oct 5 23:12 host.MYD
54 -rw-rw---- 1 mysql mysql 2048 Oct 5 23:12 host.MYI
55 -rw-rw---- 1 mysql mysql 1629 Oct 5 23:12 index_stats.frm
56 -rw-rw---- 1 mysql mysql 0 Oct 5 23:12 index_stats.MYD
57 -rw-rw---- 1 mysql mysql 4096 Oct 5 23:12 index_stats.MYI
58 -rw-rw---- 1 mysql mysql 4998 Oct 5 23:12 innodb_index_stats.frm
59 -rw-rw---- 1 mysql mysql 98304 Oct 5 23:12 innodb_index_stats.ibd
60 -rw-rw---- 1 mysql mysql 1503 Oct 5 23:12 innodb_table_stats.frm
61 -rw-rw---- 1 mysql mysql 98304 Oct 5 23:12 innodb_table_stats.ibd
62 -rw-rw---- 1 mysql mysql 1518 Oct 5 23:12 plugin.frm
63 -rw-rw---- 1 mysql mysql 0 Oct 5 23:12 plugin.MYD
64 -rw-rw---- 1 mysql mysql 1024 Oct 5 23:12 plugin.MYI
65 -rw-rw---- 1 mysql mysql 3418 Oct 5 23:12 proc.frm
66 -rw-rw---- 1 mysql mysql 0 Oct 5 23:12 proc.MYD
67 -rw-rw---- 1 mysql mysql 2048 Oct 5 23:12 proc.MYI
68 -rw-rw---- 1 mysql mysql 2874 Oct 5 23:12 procs_priv.frm
69 -rw-rw---- 1 mysql mysql 0 Oct 5 23:12 procs_priv.MYD
70 -rw-rw---- 1 mysql mysql 4096 Oct 5 23:12 procs_priv.MYI
71 -rw-rw---- 1 mysql mysql 2839 Oct 5 23:12 proxies_priv.frm
72 -rw-rw---- 1 mysql mysql 2538 Oct 5 23:12 proxies_priv.MYD
73 -rw-rw---- 1 mysql mysql 10240 Oct 5 23:12 proxies_priv.MYI
74 -rw-rw---- 1 mysql mysql 1661 Oct 5 23:12 roles_mapping.frm
75 -rw-rw---- 1 mysql mysql 0 Oct 5 23:12 roles_mapping.MYD
76 -rw-rw---- 1 mysql mysql 4096 Oct 5 23:12 roles_mapping.MYI
77 -rw-rw---- 1 mysql mysql 2703 Oct 5 23:12 servers.frm
78 -rw-rw---- 1 mysql mysql 0 Oct 5 23:12 servers.MYD
79 -rw-rw---- 1 mysql mysql 1024 Oct 5 23:12 servers.MYI
80 -rw-rw---- 1 mysql mysql 35 Oct 5 23:12 slow_log.CSM
81 -rw-rw---- 1 mysql mysql 0 Oct 5 23:12 slow_log.CSV
82 -rw-rw---- 1 mysql mysql 2339 Oct 5 23:12 slow_log.frm
83 -rw-rw---- 1 mysql mysql 2957 Oct 5 23:12 tables_priv.frm
84 -rw-rw---- 1 mysql mysql 0 Oct 5 23:12 tables_priv.MYD
85 -rw-rw---- 1 mysql mysql 4096 Oct 5 23:12 tables_priv.MYI
86 -rw-rw---- 1 mysql mysql 1374 Oct 5 23:12 table_stats.frm
87 -rw-rw---- 1 mysql mysql 0 Oct 5 23:12 table_stats.MYD
88 -rw-rw---- 1 mysql mysql 2048 Oct 5 23:12 table_stats.MYI
89 -rw-rw---- 1 mysql mysql 973 Oct 5 23:12 time_zone.frm
90 -rw-rw---- 1 mysql mysql 971 Oct 5 23:12 time_zone_leap_second.frm
91 -rw-rw---- 1 mysql mysql 0 Oct 5 23:12 time_zone_leap_second.MYD
92 -rw-rw---- 1 mysql mysql 1024 Oct 5 23:12 time_zone_leap_second.MYI
93 -rw-rw---- 1 mysql mysql 0 Oct 5 23:12 time_zone.MYD
94 -rw-rw---- 1 mysql mysql 1024 Oct 5 23:12 time_zone.MYI
95 -rw-rw---- 1 mysql mysql 1146 Oct 5 23:12 time_zone_name.frm
96 -rw-rw---- 1 mysql mysql 0 Oct 5 23:12 time_zone_name.MYD
97 -rw-rw---- 1 mysql mysql 1024 Oct 5 23:12 time_zone_name.MYI
98 -rw-rw---- 1 mysql mysql 1013 Oct 5 23:12 time_zone_transition.frm
99 -rw-rw---- 1 mysql mysql 0 Oct 5 23:12 time_zone_transition.MYD
100 -rw-rw---- 1 mysql mysql 1024 Oct 5 23:12 time_zone_transition.MYI
101 -rw-rw---- 1 mysql mysql 1079 Oct 5 23:12 time_zone_transition_type.frm
102 -rw-rw---- 1 mysql mysql 0 Oct 5 23:12 time_zone_transition_type.MYD
103 -rw-rw---- 1 mysql mysql 1024 Oct 5 23:12 time_zone_transition_type.MYI
104 -rw-rw---- 1 mysql mysql 2879 Oct 5 23:12 user.frm
105 -rw-rw---- 1 mysql mysql 556 Oct 5 23:18 user.MYD
106 -rw-rw---- 1 mysql mysql 4096 Oct 5 23:18 user.MYI
/usr/lib64/mysql/plugin
1 [root@Pridd ~]# ls -al /usr/lib64/mysql/plugin
2 total 728
3 drwxr-xr-x 2 root root 4096 Sep 14 19:30 ./
4 drwxr-xr-x 3 root root 4096 Aug 7 09:50 ../
5 -rwxr-xr-x 1 root root 11760 Sep 4 13:36 auth_pam.so*
6 -rwxr-xr-x 1 root root 7496 Sep 4 13:36 auth_socket.so*
7 -rwxr-xr-x 1 root root 11480 Sep 4 13:36 dialog.so*
8 -rwxr-xr-x 1 root root 84128 Sep 4 13:36 feedback.so*
9 -rwxr-xr-x 1 root root 74064 Sep 4 13:36 ha_archive.so*
10 -rwxr-xr-x 1 root root 45032 Sep 4 13:36 ha_blackhole.so*
11 -rwxr-xr-x 1 root root 107384 Sep 4 13:36 ha_federatedx.so*
12 -rwxr-xr-x 1 root root 174592 Sep 4 13:36 handlersocket.so*
13 -rwxr-xr-x 1 root root 11976 Sep 4 13:36 locales.so*
14 -rwxr-xr-x 1 root root 12040 Sep 4 13:35 metadata_lock_info.so*
15 -rwxr-xr-x 1 root root 7304 Sep 4 13:36 mysql_clear_password.so*
16 -rwxr-xr-x 1 root root 11920 Sep 4 13:36 query_cache_info.so*
17 -rwxr-xr-x 1 root root 16432 Sep 4 13:36 query_response_time.so*
18 -rwxr-xr-x 1 root root 42128 Sep 4 13:36 semisync_master.so*
19 -rwxr-xr-x 1 root root 16296 Sep 4 13:36 semisync_slave.so*
20 -rwxr-xr-x 1 root root 66040 Sep 4 13:36 server_audit.so*
21 -rwxr-xr-x 1 root root 12048 Sep 4 13:36 sql_errlog.so*
/var/log/mysqld/mysqld.log
1 [root@Pridd ~]# cat /var/log/mysqld/mysqld.log
2 151005 23:12:55 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
3 151005 23:12:55 [Note] /usr/sbin/mysqld (mysqld 10.0.21-MariaDB) starting as process 29765 ...
4 2015-10-05 23:12:55 7f3918aab780 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the "InnoDB's" internal memory allocator.
5 151005 23:12:55 [Note] InnoDB: Using mutexes to ref count buffer pool pages
6 151005 23:12:55 [Note] InnoDB: The InnoDB memory heap is disabled
7 151005 23:12:55 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
8 151005 23:12:55 [Note] InnoDB: Memory barrier is not used
9 151005 23:12:55 [Note] InnoDB: Compressed tables use zlib 1.2.8
10 151005 23:12:55 [Note] InnoDB: Using Linux native AIO
11 151005 23:12:55 [Note] InnoDB: Using CPU crc32 instructions
12 151005 23:12:55 [Note] InnoDB: Initializing buffer pool, size = 16.0M
13 151005 23:12:55 [Note] InnoDB: Completed initialization of buffer pool
14 151005 23:12:55 [Note] InnoDB: Highest supported file format is Barracuda.
15 151005 23:12:55 [Note] InnoDB: 128 rollback segment(s) are active.
16 151005 23:12:55 [Note] InnoDB: Waiting for purge to start
17 151005 23:12:55 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.25-73.1 started; log sequence number 1616714
18 handlersocket: initialized
19 151005 23:12:55 server_audit: MariaDB Audit Plugin version 1.3.0 STARTED.
20 151005 23:12:55 [Note] Event Scheduler: Loaded 0 events
21 151005 23:12:55 [Note] /usr/sbin/mysqld: ready for connections.
22 Version: '10.0.21-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 0 Mageia MariaDB Server
23 151005 23:17:56 [Note] feedback plugin: report to 'https://mariadb.org/feedback_plugin/post' was sent
24 151005 23:17:58 [Note] feedback plugin: server replied 'ok'
/var/run/mysqld/mysqld.pid
1 [root@Pridd ~]# ls -al /var/run/mysqld/mysqld.pid
2 -rw-rw---- 1 mysql mysql 6 Oct 5 23:12 /var/run/mysqld/mysqld.pid
3
4 [root@Pridd ~]# cat /var/run/mysqld/mysqld.pid
5 29765
6
7 [root@Pridd ~]# ps aux | grep mysqld
8 root 2539 0.0 0.0 15500 2568 pts/0 S+ 01:04 0:00 grep --color mysqld
9 mysql 29765 0.0 1.4 526896 57844 ? Sl Oct05 0:02 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql
10 /plugin --log-error=/var/log/mysqld/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock --port=3306
