另一個MySQL DBA: 百勝安裝MariaDB的/ MySQL的災難，但固定的

Original post: http://anothermysqldba.blogspot.com/2013/06/yum-install-mariadbmysql-disaster-but.html

因此，這應該是一個簡單的MariaDB的/ MySQL的安裝。我不認為這是一個瑪利亞問題，但只是一個整體的錯誤。這裡是發生了什麼事，我怎麼固定它。

yum安裝MariaDB的服務器
然後我說休息，有什麼你看到下面。

[root@Fedora64 log]# rpm -qa | grep maria 
 mariadb-5.5.31-1.fc17.x86_64 
 mariadb-server-5.5.31-1.fc17.x86_64 
 mariadb-libs-5.5.31-1.fc17.x86_64 
 mariadb-devel-5.5.31-1.fc17.x86_64

我認為這是奇怪的是，我沒有得到一個/ etc / init.d / mysql下的文件，但我用它去，我想看看發生了什麼事。

[root@Fedora64 log]# mysqld_safe 
 130608 19:54:36 mysqld_safe Logging to '/var/log/mysqld.log'. 
 130608 19:54:37 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 
 130608 19:54:39 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 
 
 130608 19:54:37 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 
 130608 19:54:37 InnoDB: The InnoDB memory heap is disabled 
 130608 19:54:37 InnoDB: Mutexes and rw_locks use GCC atomic builtins 
 130608 19:54:37 InnoDB: Compressed tables use zlib 1.2.5 
 130608 19:54:37 InnoDB: Using Linux native AIO 
 130608 19:54:37 InnoDB: Initializing buffer pool, size = 128.0M 
 130608 19:54:37 InnoDB: Completed initialization of buffer pool 
 130608 19:54:37 InnoDB: highest supported file format is Barracuda. 
 130608 19:54:38  InnoDB: Waiting for the background threads to start 
 130608 19:54:39 Percona XtraDB (http://www.percona.com) 5.5.31-MariaDB-30.2 started; log sequence number 1597945 
 130608 19:54:39 [Note] Plugin 'FEEDBACK' is disabled. 
 130608 19:54:39 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 
 130608 19:54:39 [Note] Server socket created on IP: '0.0.0.0'. 
 130608 19:54:39 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 
 130608 19:54:39 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

哇... 第一次運行和失敗是不是一個好兆頭。這是一個全新的安裝mysql目錄應該已經安裝。於是我開始與 - 跳過批表，這樣我就可以進入禁區，環顧四周。

[root@Fedora64 mysql]# ls -la 
 total 28700 
 drwxr-xr-x.  2 mysql mysql     4096 Jun  8 19:58 . 
 drwxr-xr-x. 43 root  root      4096 Jun  8 19:41 .. 
 -rw-rw----.  1 mysql mysql    16384 Jun  8 19:50 aria_log.00000001 
 -rw-rw----.  1 mysql mysql       52 Jun  8 19:50 aria_log_control 
 -rw-rw----.  1 mysql mysql 18874368 Jun  8 19:50 ibdata1 
 -rw-rw----.  1 mysql mysql  5242880 Jun  8 19:58 ib_logfile0 
 -rw-rw----.  1 mysql mysql  5242880 Jun  8 19:45 ib_logfile1 
 [root@Fedora64 mysql]# 
 
 [root@Fedora64 mysql]# mysqld_safe --skip-grant-tables 
 130608 20:02:45 mysqld_safe Logging to '/var/log/mysqld.log'. 
 130608 20:02:45 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

確定開始... 不運行，但仍然是一個主要的問題仍然沒有mysql表！

[root@Fedora64 /]# mysql_upgrade 
 Phase 1/3: Fixing table and database names 
 Phase 2/3: Checking and upgrading tables 
 Processing databases 
 information_schema 
 Phase 3/3: Running 'mysql_fix_privilege_tables'... 
 ERROR 1049 (42000): Unknown database 'mysql' 
 FATAL ERROR: Upgrade failed

這仍然可以被固定....

[root@Fedora64 /]# mysql 
 Welcome to the MariaDB monitor.  Commands end with ; or \g. 
 Your MariaDB connection id is 10 
 Server version: 5.5.31-MariaDB MariaDB Server 
 
 Copyright (c) 2000, 2013, Oracle, Monty Program Ab and others. 
 
 Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. 
 
 MariaDB [(none)]> show databases; 
 +--------------------+ 
 | Database           | 
 +--------------------+ 
 | information_schema | 
 +--------------------+ 
 1 row in set (0.01 sec) 
 
 MariaDB [(none)]> create database mysql ; 
 Query OK, 1 row affected (0.13 sec) 
 
 MariaDB [(none)]> exit 
 Bye

OK，現在它有一個mysql表，我應該能夠把它升級

[root@Fedora64 /]# mysql_upgrade 
 Phase 1/3: Fixing table and database names 
 Phase 2/3: Checking and upgrading tables 
 Processing databases 
 information_schema 
 mysql 
 Phase 3/3: Running 'mysql_fix_privilege_tables'... 
 OK 
 [root@Fedora64 /]#

確定，所以我停止mysqld和啟動它而沒有 - 跳補助畢竟剛安裝了它，我還沒有設置密碼。

[root@Fedora64 mysql]# mysqld_safe 
 [root@Fedora64 /]# mysql 
 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

好了，所以讓我再試一次......

[root@Fedora64 mysql]# mysqld_safe --skip-grant-tables 
 
 MariaDB [mysql]> show tables; 
 +---------------------------+ 
 | Tables_in_mysql           | 
 +---------------------------+ 
 | columns_priv              | 
 | db                        | 
 | event                     | 
 | func                      | 
 | general_log               | 
 | help_category             | 
 | help_keyword              | 
 | help_relation             | 
 | help_topic                | 
 | host                      | 
 | ndb_binlog_index          | 
 | plugin                    | 
 | proc                      | 
 | procs_priv                | 
 | proxies_priv              | 
 | servers                   | 
 | slow_log                  | 
 | tables_priv               | 
 | time_zone                 | 
 | time_zone_leap_second     | 
 | time_zone_name            | 
 | time_zone_transition      | 
 | time_zone_transition_type | 
 | user                      | 
 +---------------------------+ 
 24 rows in set (0.01 sec) 
 
 MariaDB [mysql]> select * from user; 
 Empty set (0.00 sec) 
 
 MariaDB [(none)]>  create user root ;

我不能使用下面的命令，因為啟用 - 跳批表。
建立用戶根確定“;

所以現在我有一個root用戶只能通過名字，因為它具有零權限。

MariaDB [(none)]> show databases; 
 +--------------------+ 
 | Database           | 
 +--------------------+ 
 | information_schema | 
 +--------------------+ 
 1 row in set (0.00 sec)

所以我要再次入禁區 - 啟用跳過批表，更新根帳戶

UPDATE user 
 SET Select_priv = 'Y', 
 Insert_priv='Y', 
 Update_priv='Y', 
 Delete_priv='Y', 
 Create_priv='Y', 
 Drop_priv='Y', 
 Reload_priv='Y', 
 Shutdown_priv='Y', 
 Process_priv='Y', 
 File_priv='Y', 
 Grant_priv='Y', 
 References_priv='Y', 
 Index_priv='Y', 
 Alter_priv='Y', 
 Show_db_priv='Y', 
 Super_priv='Y', 
 Create_tmp_table_priv='Y', 
 Lock_tables_priv='Y', 
 Execute_priv='Y', 
 Repl_slave_priv='Y', 
 Repl_client_priv='Y', 
 Create_view_priv='Y', 
 Show_view_priv='Y', 
 Create_routine_priv='Y', 
 Alter_routine_priv='Y', 
 Create_user_priv='Y', 
 Event_priv='Y', 
 Trigger_priv='Y', 
 Create_tablespace_priv='Y' 
 WHERE user = 'root';

現在不重新啟動 - 啟用跳過發放表，我作為root！

[root@Fedora64 /]# ps -ef | grep mysql 
 root      4522  1513  0 20:26 pts/0    00:00:00 /bin/sh /bin/mysqld_safe 

 mysql     4650  4522  0 20:27 pts/0    00:00:03 /usr/libexec/mysqld 
--basedir=/usr --datadir=/var/lib/mysql 
--plugin-dir=/usr/lib64/mysql/plugin --user=mysql 
--log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid 
--socket=/var/lib/mysql/mysql.sock 
 root      8348  3178  0 20:47 pts/1    00:00:00 grep --color=auto mysql 
 [root@Fedora64 /]# mysql 
 Welcome to the MariaDB monitor.  Commands end with ; or \g. 
 Your MariaDB connection id is 2 
 Server version: 5.5.31-MariaDB MariaDB Server 
 
 Copyright (c) 2000, 2013, Oracle, Monty Program Ab and others. 
 
 Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. 
 
 MariaDB [(none)]>

噢。這是一個例子，如何解決它，當事情出錯，但我還是想在/ etc / init.d / mysql下的文件

另一個MySQL DBA

Pages

2013年6月9日星期日

百勝安裝MariaDB的/ MySQL的災難，但固定的