You are not logged in.
Hi,
It started when I dropped root user in mysql. I panicked and removed mariadb by yaourt, and any of files "mysql" name(manually).
Later I installed mariadb again. While install i get this output:
Installing MariaDB/MySQL system tables in './data' ...
141113 22:41:22 [Note] InnoDB: Using mutexes to ref count buffer pool pages
141113 22:41:22 [Note] InnoDB: The InnoDB memory heap is disabled
141113 22:41:22 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
141113 22:41:22 [Note] InnoDB: Memory barrier is not used
141113 22:41:22 [Note] InnoDB: Compressed tables use zlib 1.2.8
141113 22:41:22 [Note] InnoDB: Using Linux native AIO
141113 22:41:22 [Note] InnoDB: Using CPU crc32 instructions
141113 22:41:22 [Note] InnoDB: Initializing buffer pool, size = 128.0M
141113 22:41:22 [Note] InnoDB: Completed initialization of buffer pool
141113 22:41:22 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
141113 22:41:22 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
141113 22:41:22 [Note] InnoDB: Database physically writes the file full: wait...
141113 22:41:22 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
141113 22:41:23 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
141113 22:41:24 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
141113 22:41:24 [Warning] InnoDB: New log files created, LSN=45781
141113 22:41:24 [Note] InnoDB: Doublewrite buffer not found: creating new
141113 22:41:24 [Note] InnoDB: Doublewrite buffer created
141113 22:41:24 [Note] InnoDB: 128 rollback segment(s) are active.
141113 22:41:24 [Warning] InnoDB: Creating foreign key constraint system tables.
141113 22:41:24 [Note] InnoDB: Foreign key constraint system tables created
141113 22:41:24 [Note] InnoDB: Creating tablespace and datafile system tables.
141113 22:41:24 [Note] InnoDB: Tablespace and datafile system tables created.
141113 22:41:24 [Note] InnoDB: Waiting for purge to start
141113 22:41:24 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.20-68.0 started; log sequence number 0
141113 22:41:24 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
141113 22:41:28 [Note] InnoDB: FTS optimize thread exiting.
141113 22:41:28 [Note] InnoDB: Starting shutdown...
141113 22:41:30 [Note] InnoDB: Shutdown completed; log sequence number 1616697
OK
Filling help tables...
141113 22:41:31 [Note] InnoDB: Using mutexes to ref count buffer pool pages
141113 22:41:31 [Note] InnoDB: The InnoDB memory heap is disabled
141113 22:41:31 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
141113 22:41:31 [Note] InnoDB: Memory barrier is not used
141113 22:41:31 [Note] InnoDB: Compressed tables use zlib 1.2.8
141113 22:41:31 [Note] InnoDB: Using Linux native AIO
141113 22:41:31 [Note] InnoDB: Using CPU crc32 instructions
141113 22:41:31 [Note] InnoDB: Initializing buffer pool, size = 128.0M
141113 22:41:31 [Note] InnoDB: Completed initialization of buffer pool
141113 22:41:31 [Note] InnoDB: Highest supported file format is Barracuda.
141113 22:41:31 [Note] InnoDB: 128 rollback segment(s) are active.
141113 22:41:31 [Note] InnoDB: Waiting for purge to start
141113 22:41:31 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.20-68.0 started; log sequence number 1616697
141113 22:41:31 [Note] InnoDB: FTS optimize thread exiting.
141113 22:41:31 [Note] InnoDB: Starting shutdown...
141113 22:41:33 [Note] InnoDB: Shutdown completed; log sequence number 1616707
OK
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
To do so, start the server, then issue the following commands:
'/usr/bin/mysqladmin' -u root password 'new-password'
'/usr/bin/mysqladmin' -u root -h laptop password 'new-password'
Alternatively you can run:
'/usr/bin/mysql_secure_installation'
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the MariaDB Knowledgebase at http://mariadb.com/kb or the
MySQL manual for more instructions.
You can start the MariaDB daemon with:
cd '/usr' ; /usr/bin/mysqld_safe --datadir='./data'
You can test the MariaDB daemon with mysql-test-run.pl
cd '/usr/mysql-test' ; perl mysql-test-run.pl
Please report any problems at http://mariadb.org/jira
The latest information about MariaDB is available at http://mariadb.org/.
You can find additional information about the MySQL part at:
http://dev.mysql.com
Support MariaDB development by buying support/new features from
SkySQL Ab. You can contact us about this at sales@skysql.com.
Alternatively consider joining our community based development effort:
http://mariadb.com/kb/en/contributing-to-the-mariadb-project/here are 2 warnings, but i ignored them.
next step(following wiki) is running mysqld.service. I try, and the output is:
Job for mysqld.service failed. See "systemctl status mysqld.service" and "journalctl -xe" for details.next:
systemctl status mysqld.service
● mysqld.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled)
Active: activating (start-post) since Thu 2014-11-13 22:48:14 CET; 57s ago
Main PID: 6692 (mysqld); : 6693 (mysqld-post)
CGroup: /system.slice/mysqld.service
├─6692 /usr/bin/mysqld --pid-file=/run/mysqld/mysqld.pid
└─control
├─6693 /bin/sh /usr/bin/mysqld-post
└─7119 sleep 1
Nov 13 22:48:14 laptop mysqld[6692]: 141113 22:48:14 [Note] InnoDB: Completed initialization of buffer pool
Nov 13 22:48:14 laptop mysqld[6692]: 141113 22:48:14 [Note] InnoDB: Highest supported file format is Barracuda.
Nov 13 22:48:14 laptop mysqld[6692]: 141113 22:48:14 [Note] InnoDB: 128 rollback segment(s) are active.
Nov 13 22:48:14 laptop mysqld[6692]: 141113 22:48:14 [Note] InnoDB: Waiting for purge to start
Nov 13 22:48:14 laptop mysqld[6692]: 141113 22:48:14 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.20-68.0 started; log sequence number 1616857
Nov 13 22:48:14 laptop mysqld[6692]: 141113 22:48:14 [Note] Plugin 'FEEDBACK' is disabled.
Nov 13 22:48:14 laptop mysqld[6692]: 141113 22:48:14 [Note] Server socket created on IP: '::'.
Nov 13 22:48:14 laptop mysqld[6692]: 141113 22:48:14 [Note] Event Scheduler: Loaded 0 events
Nov 13 22:48:14 laptop mysqld[6692]: 141113 22:48:14 [Note] /usr/bin/mysqld: ready for connections.
Nov 13 22:48:14 laptop mysqld[6692]: Version: '10.0.14-MariaDB-log' socket: '/run/mysqld/mysqld.sock' port: 3306 MariaDB Servermore:
journalctl -xe
--
-- Unit mysqld.service has failed.
--
-- The result is failed.
Nov 13 22:48:13 laptop systemd[1]: Unit mysqld.service entered failed state.
Nov 13 22:48:13 laptop systemd[1]: mysqld.service failed.
Nov 13 22:48:13 laptop sudo[6328]: pam_unix(sudo:session): session closed for user root
Nov 13 22:48:14 laptop systemd[1]: mysqld.service holdoff time over, scheduling restart.
Nov 13 22:48:14 laptop systemd[1]: Stopping MariaDB database server...
-- Subject: Unit mysqld.service has begun shutting down
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysqld.service has begun shutting down.
Nov 13 22:48:14 laptop systemd[1]: Starting MariaDB database server...
-- Subject: Unit mysqld.service has begun with start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysqld.service has begun starting up.
Nov 13 22:48:14 laptop mysqld[6692]: 141113 22:48:14 [Note] InnoDB: Using mutexes to ref count buffer pool pages
Nov 13 22:48:14 laptop mysqld[6692]: 141113 22:48:14 [Note] InnoDB: The InnoDB memory heap is disabled
Nov 13 22:48:14 laptop mysqld[6692]: 141113 22:48:14 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Nov 13 22:48:14 laptop mysqld[6692]: 141113 22:48:14 [Note] InnoDB: Memory barrier is not used
Nov 13 22:48:14 laptop mysqld[6692]: 141113 22:48:14 [Note] InnoDB: Compressed tables use zlib 1.2.8
Nov 13 22:48:14 laptop mysqld[6692]: 141113 22:48:14 [Note] InnoDB: Using Linux native AIO
Nov 13 22:48:14 laptop mysqld[6692]: 141113 22:48:14 [Note] InnoDB: Using CPU crc32 instructions
Nov 13 22:48:14 laptop mysqld[6692]: 141113 22:48:14 [Note] InnoDB: Initializing buffer pool, size = 128.0M
Nov 13 22:48:14 laptop mysqld[6692]: 141113 22:48:14 [Note] InnoDB: Completed initialization of buffer pool
Nov 13 22:48:14 laptop mysqld[6692]: 141113 22:48:14 [Note] InnoDB: Highest supported file format is Barracuda.
Nov 13 22:48:14 laptop mysqld[6692]: 141113 22:48:14 [Note] InnoDB: 128 rollback segment(s) are active.
Nov 13 22:48:14 laptop mysqld[6692]: 141113 22:48:14 [Note] InnoDB: Waiting for purge to start
Nov 13 22:48:14 laptop mysqld[6692]: 141113 22:48:14 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.20-68.0 started; log sequence number 1616857
Nov 13 22:48:14 laptop mysqld[6692]: 141113 22:48:14 [Note] Plugin 'FEEDBACK' is disabled.
Nov 13 22:48:14 laptop mysqld[6692]: 141113 22:48:14 [Note] Server socket created on IP: '::'.
Nov 13 22:48:14 laptop mysqld[6692]: 141113 22:48:14 [Note] Event Scheduler: Loaded 0 events
Nov 13 22:48:14 laptop mysqld[6692]: 141113 22:48:14 [Note] /usr/bin/mysqld: ready for connections.
Nov 13 22:48:14 laptop mysqld[6692]: Version: '10.0.14-MariaDB-log' socket: '/run/mysqld/mysqld.sock' port: 3306 MariaDB Server
Nov 13 22:48:58 laptop sudo[7027]: rlk120 : TTY=pts/0 ; PWD=/home/rlk120 ; USER=root ; COMMAND=/usr/bin/systemctl status mysqld.service
Nov 13 22:48:58 laptop sudo[7027]: pam_unix(sudo:session): session opened for user root by rlk120(uid=0)
Nov 13 22:48:58 laptop sudo[7027]: pam_unix(sudo:session): session closed for user root
Nov 13 22:49:03 laptop kernel: perf interrupt took too long (2515 > 2495), lowering kernel.perf_event_max_sample_rate to 50100
Nov 13 22:49:11 laptop sudo[7120]: rlk120 : TTY=pts/0 ; PWD=/home/rlk120 ; USER=root ; COMMAND=/usr/bin/systemctl status mysqld.service
Nov 13 22:49:11 laptop sudo[7120]: pam_unix(sudo:session): session opened for user root by rlk120(uid=0)
Nov 13 22:49:11 laptop sudo[7120]: pam_unix(sudo:session): session closed for user rootAnybody can help? I considered even reinstall Arch because of this, i really need fast fix this database.
Offline