--- On Sat, 11/1/08, Reg Clemens <reg@xxxxxxx> wrote: > From: Reg Clemens <reg@xxxxxxx> > Subject: Help starting mysql. > To: fedora-list@xxxxxxxxxx > 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@xxxxxxx 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@xxxxxxxxxx > To unsubscribe: > https://www.redhat.com/mailman/listinfo/fedora-list > Guidelines: > http://fedoraproject.org/wiki/Communicate/MailingListGuidelines -- fedora-list mailing list fedora-list@xxxxxxxxxx To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list Guidelines: http://fedoraproject.org/wiki/Communicate/MailingListGuidelines
