Curso de MariaDB Desde la Consola/iniciar el Servicio

De WikiCabal
< Curso de MariaDB Desde la Consola
Revisión del 19:11 22 oct 2015 de Rrc (discusión | contribuciones)
(dif) ← Revisión anterior | Revisión actual (dif) | Revisión siguiente → (dif)
Ir a la navegación Ir a la búsqueda

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