When I do a mysqld start (from /etc/rc.d/init.d), there is a long pause, mabe a minute, and then the message Starting MySQL: [FAILED]
The first time I tried starting mysql, I saw in the mysql.log file the following messages
---
081028 14:41:25 mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 081028 14:41:25 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 081028 14:41:25 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 081028 14:41:25 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 081028 14:41:26 InnoDB: Started; log sequence number 0 0 081028 14:41:26 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 081028 14:41:26 mysqld ended
---
Starting the 2nd time, I see the messages
---
081101 00:30:36 mysqld started 081101 0:30:36 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 081101 0:30:36 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 36808. InnoDB: Doing recovery: scanned up to log sequence number 0 43655 081101 0:30:36 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed 081101 0:30:36 InnoDB: Started; log sequence number 0 43655 081101 0:30:36 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 081101 00:30:36 mysqld ended
---
I dont remember this error from when I used mysql before. Whats going on here, and how do I get the daemon started so I can actually send mysql commands to setup the database?
On Sat, Nov 01, 2008 at 12:45:40AM -0600, Reg Clemens wrote:
081028 14:41:26 [ERROR] Fatal error: Can't open and lock privilege tables: 081101 0:30:36 [ERROR] Fatal error: Can't open and lock privilege tables:
Make sure you're starting /etc/init.d/mysqld as root. If you haven't already, you could try executing mysql_secure_installation as root.
Ian
Reg Clemens wrote:
When I do a mysqld start (from /etc/rc.d/init.d), there is a long pause, mabe a minute, and then the message Starting MySQL: [FAILED]
The first time I tried starting mysql, I saw in the mysql.log file the following messages
081028 14:41:25 mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 081028 14:41:25 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 081028 14:41:25 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 081028 14:41:25 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 081028 14:41:26 InnoDB: Started; log sequence number 0 0 081028 14:41:26 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 081028 14:41:26 mysqld ended
The database management tables need to be created/initialized.
Try "mysql_install_db". After that you should be good to go.
hth, :m)
Reg Clemens wrote:
When I do a mysqld start (from /etc/rc.d/init.d), there is a long pause, mabe a minute, and then the message Starting MySQL: [FAILED]
The first time I tried starting mysql, I saw in the mysql.log file the following messages
081028 14:41:25 mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 081028 14:41:25 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 081028 14:41:25 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 081028 14:41:25 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 081028 14:41:26 InnoDB: Started; log sequence number 0 0 081028 14:41:26 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 081028 14:41:26 mysqld ended
The database management tables need to be created/initialized.
Try "mysql_install_db". After that you should be good to go.
Sorry, this command was not understood by mysql-5.0.27-1.fc6 in fc6.
On Sat, Nov 01, 2008 at 12:45:40AM -0600, Reg Clemens wrote:
When I do a mysqld start (from /etc/rc.d/init.d), there is a long pause, mabe a minute, and then the message Starting MySQL: [FAILED]
The first time I tried starting mysql, I saw in the mysql.log file the following messages
[...snip...]
081028 14:41:26 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 081028 14:41:26 mysqld ended
It would be helpful to know the release of Fedora you're running on (9?), and your version of mysql:
$ rpm -q mysql # What does this command report for you?
I'm guessing this bug might pertain to you: https://bugzilla.redhat.com/show_bug.cgi?id=450178
On Sat, Nov 01, 2008 at 12:45:40AM -0600, Reg Clemens wrote:
When I do a mysqld start (from /etc/rc.d/init.d), there is a long pause, mabe a minute, and then the message Starting MySQL: [FAILED]
The first time I tried starting mysql, I saw in the mysql.log file the following messages
[...snip...]
081028 14:41:26 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 081028 14:41:26 mysqld ended
It would be helpful to know the release of Fedora you're running on (9?), and your version of mysql:
This is mysql-5.0.27-1.fc6 in fc6. And as I noted, I have a running copy of the same mysql on a different machine.
--- On Sat, 11/1/08, Reg Clemens reg@dwf.com wrote:
From: Reg Clemens reg@dwf.com Subject: Help starting mysql. To: fedora-list@redhat.com Date: Saturday, November 1, 2008, 6:45 AM When I do a mysqld start (from /etc/rc.d/init.d), there is a long pause, mabe a minute, and then the message Starting MySQL: [FAILED]
The first time I tried starting mysql, I saw in the mysql.log file the following messages
081028 14:41:25 mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 081028 14:41:25 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 081028 14:41:25 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 081028 14:41:25 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 081028 14:41:26 InnoDB: Started; log sequence number 0 0 081028 14:41:26 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 081028 14:41:26 mysqld ended
Starting the 2nd time, I see the messages
081101 00:30:36 mysqld started 081101 0:30:36 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 081101 0:30:36 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 36808. InnoDB: Doing recovery: scanned up to log sequence number 0 43655 081101 0:30:36 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed 081101 0:30:36 InnoDB: Started; log sequence number 0 43655 081101 0:30:36 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 081101 00:30:36 mysqld ended
I dont remember this error from when I used mysql before. Whats going on here, and how do I get the daemon started so I can actually send mysql commands to setup the database? -- Reg.Clemens reg@dwf.com
Fedora 9
[oracle@XXX ~]$ kde4-config --version Qt: 4.4.3 KDE: 4.1.2 (KDE 4.1.2) kde4-config: 1.0
(1) click fedora icon far left (2) administration>service management (gear icon) (3) find mysqld and enable,start..wait for the green light
under root
mysql
mysql>create user fredsilsbee; mysql>grant all on *.* to fredsilsbee@localhost identified by 'password';
mysql>create database fredx;
get out of root to another user fredxyz
mysql -h localhost -u fredsilsbee -p this works
mysql -h localhost -u fredsilsbee -p -D fredx this works
mysql -u fredsilsbee -p -D fredx this works
mysqlshow -u fredsilsbee -p fredx this works
mysql -u fredsilsbee --password='3141' this works
fredx is the database name
-- fedora-list mailing list fedora-list@redhat.com To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list Guidelines: http://fedoraproject.org/wiki/Communicate/MailingListGuidelines
-
Fred Silsbee -
Ian Hilt -
Mike Wright -
Paul W. Frields -
Reg Clemens