Re: database won't load after machine reboot
Hello. Is there any way I can reset the root password? (Ouch). See: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html Luke Vanderfluit wrote: Hi David. Thanks for your help. Logan, David (SST - Adelaide) wrote: Hi Luke, Have you tried doing another GRANT statement to ensure the name and password are indeed correct? That would be my next step. That way at least you are sure that the name/password combination are correct. I can't access the database as root anymore. Accessing as other users doesn't allow me to set any GRANT statements. Is there any way I can reset the root password? (Ouch). Kr. Luke. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: database won't load after machine reboot
on 10/19/05 7:47 PM, Luke Vanderfluit at [EMAIL PROTECTED] wrote: I can't access the database as root anymore. Accessing as other users doesn't allow me to set any GRANT statements. Is there any way I can reset the root password? (Ouch). You probably want to start it up with the skip grants options, and reset it from there, then start it up normal: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
database won't load after machine reboot
Hi. I have a database that is used with wordpress blogging software. Yesterday the server that it's running on reset itself. Since then I can't access the database. What could be going on here? Any ideas? Thanks. Kind regards. -- Luke -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: database won't load after machine reboot
Hi. For clarity, I'm running mysql 4.0.20 And I did start the mysql daemon. Luke Vanderfluit wrote: Hi. I have a database that is used with wordpress blogging software. Yesterday the server that it's running on reset itself. Since then I can't access the database. What could be going on here? Any ideas? Thanks. Kind regards. -- Luke -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: database won't load after machine reboot
Do you have any log messages associated with it? (not sure for win / os x for linux look in /var/lib/mysql/hostname.err) Hi. For clarity, I'm running mysql 4.0.20 And I did start the mysql daemon. Luke Vanderfluit wrote: Hi. I have a database that is used with wordpress blogging software. Yesterday the server that it's running on reset itself. Since then I can't access the database. What could be going on here? Any ideas? Thanks. Kind regards. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: database won't load after machine reboot
Do you have any sample of error output? This would be useful. Thanks David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Luke Vanderfluit [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 October 2005 11:22 AM To: mysql@lists.mysql.com Subject: Re: database won't load after machine reboot Hi. For clarity, I'm running mysql 4.0.20 And I did start the mysql daemon. Luke Vanderfluit wrote: Hi. I have a database that is used with wordpress blogging software. Yesterday the server that it's running on reset itself. Since then I can't access the database. What could be going on here? Any ideas? Thanks. Kind regards. -- Luke -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: database won't load after machine reboot
Hi. Logan, David (SST - Adelaide) wrote: Do you have any sample of error output? This would be useful. I think the problem started where I have inserted the lines. Thanks. / = 050914 04:44:49 mysqld restarted 050914 4:44:53 InnoDB: Started /myProgs/mysql/libexec/mysqld: ready for connections. Version: '4.0.20-log' socket: '/tmp/mysql.sock' port: 3306 050918 0:27:35 Aborted connection 30 to db: 'unconnected' user: 'luke' host: `loc alhost' (Got timeout reading communication packets) 050923 9:01:48 Aborted connection 5931 to db: 'unconnected' user: 'luke' host: `l ocalhost' (Got an error reading communication packets) 050923 9:01:48 Aborted connection 5934 to db: 'unconnected' user: 'luke' host: `l ocalhost' (Got an error reading communication packets) 050923 9:01:48 Aborted connection 5937 to db: 'unconnected' user: 'luke' host: `l ocalhost' (Got an error reading communication packets) 050923 9:01:48 Aborted connection 5940 to db: 'unconnected' user: 'luke' host: `l ocalhost' (Got an error reading communication packets) 050923 9:01:48 Aborted connection 5943 to db: 'unconnected' user: 'luke' host: `l ocalhost' (Got an error reading communication packets) 050923 9:01:48 Aborted connection 5946 to db: 'unconnected' user: 'luke' host: `l ocalhost' (Got an error reading communication packets) 051015 14:53:20 Aborted connection 14332 to db: 'comstechIntDB' user: 'luke' host: / = `localhost' (Got an error writing communication packets) 051019 11:36:44 mysqld started 051019 11:36:44 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 6648179 InnoDB: Doing recovery: scanned up to log sequence number 0 6648179 InnoDB: Last MySQL binlog file position 0 5263271, file name ./bench-bin.015 051019 11:36:44 InnoDB: Flushing modified pages from the buffer pool... 051019 11:36:44 InnoDB: Started /myProgs/mysql/libexec/mysqld: ready for connections. Version: '4.0.20-log' socket: '/tmp/mysql.sock' port: 3306 051019 14:04:27 mysqld started 051019 14:04:27 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 6648179 InnoDB: Doing recovery: scanned up to log sequence number 0 6648179 InnoDB: Last MySQL binlog file position 0 5263271, file name ./bench-bin.015 051019 14:04:27 InnoDB: Flushing modified pages from the buffer pool... 051019 14:04:27 InnoDB: Started /myProgs/mysql/libexec/mysqld: ready for connections. Version: '4.0.20-log' socket: '/tmp/mysql.sock' port: 3306 051019 18:55:31 /myProgs/mysql/libexec/mysqld: Normal shutdown 051019 18:55:31 InnoDB: Starting shutdown... 051019 18:55:33 InnoDB: Shutdown completed 051019 18:55:33 /myProgs/mysql/libexec/mysqld: Shutdown Complete 051019 18:55:33 mysqld ended 051019 19:39:17 mysqld started 051019 19:39:18 InnoDB: Started /myProgs/mysql/libexec/mysqld: ready for connections. Version: '4.0.20-log' socket: '/tmp/mysql.sock' port: 3306 051019 19:46:11 /myProgs/mysql/libexec/mysqld: Normal shutdown 051019 19:46:11 InnoDB: Starting shutdown... 051019 19:46:14 InnoDB: Shutdown completed 051019 19:46:14 /myProgs/mysql/libexec/mysqld: Shutdown Complete 051019 19:46:14 mysqld ended 051019 19:46:20 mysqld started 051019 19:46:20 InnoDB: Started /myProgs/mysql/libexec/mysqld: ready for connections. Version: '4.0.20-log' socket: '/tmp/mysql.sock' port: 3306 Thanks David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Luke Vanderfluit [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 October 2005 11:22 AM To: mysql@lists.mysql.com Subject: Re: database won't load after machine reboot Hi. For clarity, I'm running mysql 4.0.20 And I did start the mysql daemon. Luke Vanderfluit wrote: Hi. I have a database that is used with wordpress blogging software. Yesterday the server that it's running on reset itself. Since then I can't access the database. What could be going on here? Any ideas? Thanks. Kind regards. -- Luke
RE: database won't load after machine reboot
Hi Luke, According to the log 051019 19:46:20 mysqld started 051019 19:46:20 InnoDB: Started /myProgs/mysql/libexec/mysqld: ready for connections. Version: '4.0.20-log' socket: '/tmp/mysql.sock' port: 3306 mysqld is sitting there fat, dumb and happy waiting for somebody to talk to it at either /tmp/mysql.sock or on port 3306. Are you able to connect to other databases? Have you tried connecting via the mysql client and seeing if you can get to the databases that way? This would give you an error message which could help identify what the issue is. eg. $ mysql -u user -p -h mysql hostname -D database name You could run mysqlcheck -u root -p -h mysql hostname database name and this will tell you if there is any corruption in any table. Earlier in the piece you had a crash, thats fine as InnoDB did the right thing and recovered nicely (as it should) and since then the database has been restarted a few times with no issue. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Luke Vanderfluit [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 October 2005 11:45 AM To: mysql Subject: Re: database won't load after machine reboot Hi. Logan, David (SST - Adelaide) wrote: Do you have any sample of error output? This would be useful. I think the problem started where I have inserted the lines. Thanks. / = 050914 04:44:49 mysqld restarted 050914 4:44:53 InnoDB: Started /myProgs/mysql/libexec/mysqld: ready for connections. Version: '4.0.20-log' socket: '/tmp/mysql.sock' port: 3306 050918 0:27:35 Aborted connection 30 to db: 'unconnected' user: 'luke' host: `loc alhost' (Got timeout reading communication packets) 050923 9:01:48 Aborted connection 5931 to db: 'unconnected' user: 'luke' host: `l ocalhost' (Got an error reading communication packets) 050923 9:01:48 Aborted connection 5934 to db: 'unconnected' user: 'luke' host: `l ocalhost' (Got an error reading communication packets) 050923 9:01:48 Aborted connection 5937 to db: 'unconnected' user: 'luke' host: `l ocalhost' (Got an error reading communication packets) 050923 9:01:48 Aborted connection 5940 to db: 'unconnected' user: 'luke' host: `l ocalhost' (Got an error reading communication packets) 050923 9:01:48 Aborted connection 5943 to db: 'unconnected' user: 'luke' host: `l ocalhost' (Got an error reading communication packets) 050923 9:01:48 Aborted connection 5946 to db: 'unconnected' user: 'luke' host: `l ocalhost' (Got an error reading communication packets) 051015 14:53:20 Aborted connection 14332 to db: 'comstechIntDB' user: 'luke' host: / = `localhost' (Got an error writing communication packets) 051019 11:36:44 mysqld started 051019 11:36:44 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 6648179 InnoDB: Doing recovery: scanned up to log sequence number 0 6648179 InnoDB: Last MySQL binlog file position 0 5263271, file name ./bench-bin.015 051019 11:36:44 InnoDB: Flushing modified pages from the buffer pool... 051019 11:36:44 InnoDB: Started /myProgs/mysql/libexec/mysqld: ready for connections. Version: '4.0.20-log' socket: '/tmp/mysql.sock' port: 3306 051019 14:04:27 mysqld started 051019 14:04:27 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 6648179 InnoDB: Doing recovery: scanned up to log sequence number 0 6648179 InnoDB: Last MySQL binlog file position 0 5263271, file name ./bench-bin.015 051019 14:04:27 InnoDB: Flushing modified pages from the buffer pool... 051019 14:04:27 InnoDB: Started /myProgs/mysql/libexec/mysqld: ready for connections. Version: '4.0.20-log' socket: '/tmp/mysql.sock' port: 3306 051019 18:55:31 /myProgs/mysql/libexec/mysqld: Normal shutdown 051019 18:55:31 InnoDB: Starting shutdown... 051019 18:55:33 InnoDB: Shutdown completed 051019 18:55:33 /myProgs/mysql/libexec/mysqld: Shutdown Complete 051019 18:55:33 mysqld ended 051019 19:39:17 mysqld started 051019 19:39:18 InnoDB: Started /myProgs/mysql/libexec/mysqld: ready for connections. Version: '4.0.20-log' socket: '/tmp/mysql.sock' port: 3306 051019 19:46:11 /myProgs/mysql/libexec/mysqld: Normal shutdown 051019 19:46:11 InnoDB: Starting shutdown... 051019 19:46:14 InnoDB: Shutdown completed 051019 19:46:14 /myProgs/mysql/libexec/mysqld: Shutdown Complete 051019 19:46:14 mysqld ended 051019 19:46:20 mysqld started 051019 19:46:20 InnoDB: Started /myProgs/mysql/libexec/mysqld: ready for connections. Version
Re: database won't load after machine reboot
Hi David. Logan, David (SST - Adelaide) wrote: Hi Luke, According to the log 051019 19:46:20 mysqld started 051019 19:46:20 InnoDB: Started /myProgs/mysql/libexec/mysqld: ready for connections. Version: '4.0.20-log' socket: '/tmp/mysql.sock' port: 3306 mysqld is sitting there fat, dumb and happy waiting for somebody to talk to it at either /tmp/mysql.sock or on port 3306. Are you able to connect to other databases? Yes. Have you tried connecting via the mysql client and seeing if you can get to the databases that way? This would give you an error message which could help identify what the issue is. Yes. mysql -u luke -p blog ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'blog' eg. $ mysql -u user -p -h mysql hostname -D database name You could run mysqlcheck -u root -p -h mysql hostname database name and this will tell you if there is any corruption in any table. Earlier in the piece you had a crash, thats fine as InnoDB did the right thing and recovered nicely (as it should) and since then the database has been restarted a few times with no issue. That's right. So mysql is fine. Just can't connect to the database name blog. I'm certain of the right username and password. So hmmm Kind regards. Luke. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Luke Vanderfluit [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 October 2005 11:45 AM To: mysql Subject: Re: database won't load after machine reboot Hi. Logan, David (SST - Adelaide) wrote: Do you have any sample of error output? This would be useful. I think the problem started where I have inserted the lines. Thanks. / = 050914 04:44:49 mysqld restarted 050914 4:44:53 InnoDB: Started /myProgs/mysql/libexec/mysqld: ready for connections. Version: '4.0.20-log' socket: '/tmp/mysql.sock' port: 3306 050918 0:27:35 Aborted connection 30 to db: 'unconnected' user: 'luke' host: `loc alhost' (Got timeout reading communication packets) 050923 9:01:48 Aborted connection 5931 to db: 'unconnected' user: 'luke' host: `l ocalhost' (Got an error reading communication packets) 050923 9:01:48 Aborted connection 5934 to db: 'unconnected' user: 'luke' host: `l ocalhost' (Got an error reading communication packets) 050923 9:01:48 Aborted connection 5937 to db: 'unconnected' user: 'luke' host: `l ocalhost' (Got an error reading communication packets) 050923 9:01:48 Aborted connection 5940 to db: 'unconnected' user: 'luke' host: `l ocalhost' (Got an error reading communication packets) 050923 9:01:48 Aborted connection 5943 to db: 'unconnected' user: 'luke' host: `l ocalhost' (Got an error reading communication packets) 050923 9:01:48 Aborted connection 5946 to db: 'unconnected' user: 'luke' host: `l ocalhost' (Got an error reading communication packets) 051015 14:53:20 Aborted connection 14332 to db: 'comstechIntDB' user: 'luke' host: / = `localhost' (Got an error writing communication packets) 051019 11:36:44 mysqld started 051019 11:36:44 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 6648179 InnoDB: Doing recovery: scanned up to log sequence number 0 6648179 InnoDB: Last MySQL binlog file position 0 5263271, file name ./bench-bin.015 051019 11:36:44 InnoDB: Flushing modified pages from the buffer pool... 051019 11:36:44 InnoDB: Started /myProgs/mysql/libexec/mysqld: ready for connections. Version: '4.0.20-log' socket: '/tmp/mysql.sock' port: 3306 051019 14:04:27 mysqld started 051019 14:04:27 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 6648179 InnoDB: Doing recovery: scanned up to log sequence number 0 6648179 InnoDB: Last MySQL binlog file position 0 5263271, file name ./bench-bin.015 051019 14:04:27 InnoDB: Flushing modified pages from the buffer pool... 051019 14:04:27 InnoDB: Started /myProgs/mysql/libexec/mysqld: ready for connections. Version: '4.0.20-log' socket: '/tmp/mysql.sock' port: 3306 051019 18:55:31 /myProgs/mysql/libexec/mysqld: Normal shutdown 051019 18:55:31 InnoDB: Starting shutdown... 051019 18:55:33 InnoDB: Shutdown completed 051019 18:55:33 /myProgs/mysql/libexec/mysqld: Shutdown Complete 051019 18:55:33 mysqld ended 051019 19:39:17 mysqld started 051019 19:39:18 InnoDB: Started /myProgs/mysql/libexec/mysqld: ready for connections. Version: '4.0.20-log' socket: '/tmp/mysql.sock' port: 3306 051019 19:46:11
RE: database won't load after machine reboot
Hi Luke, Have you tried doing another GRANT statement to ensure the name and password are indeed correct? That would be my next step. That way at least you are sure that the name/password combination are correct. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Luke Vanderfluit [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 October 2005 12:00 PM To: mysql Subject: Re: database won't load after machine reboot Hi David. Logan, David (SST - Adelaide) wrote: Hi Luke, According to the log 051019 19:46:20 mysqld started 051019 19:46:20 InnoDB: Started /myProgs/mysql/libexec/mysqld: ready for connections. Version: '4.0.20-log' socket: '/tmp/mysql.sock' port: 3306 mysqld is sitting there fat, dumb and happy waiting for somebody to talk to it at either /tmp/mysql.sock or on port 3306. Are you able to connect to other databases? Yes. Have you tried connecting via the mysql client and seeing if you can get to the databases that way? This would give you an error message which could help identify what the issue is. Yes. mysql -u luke -p blog ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'blog' eg. $ mysql -u user -p -h mysql hostname -D database name You could run mysqlcheck -u root -p -h mysql hostname database name and this will tell you if there is any corruption in any table. Earlier in the piece you had a crash, thats fine as InnoDB did the right thing and recovered nicely (as it should) and since then the database has been restarted a few times with no issue. That's right. So mysql is fine. Just can't connect to the database name blog. I'm certain of the right username and password. So hmmm Kind regards. Luke. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Luke Vanderfluit [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 October 2005 11:45 AM To: mysql Subject: Re: database won't load after machine reboot Hi. Logan, David (SST - Adelaide) wrote: Do you have any sample of error output? This would be useful. I think the problem started where I have inserted the lines. Thanks. / = 050914 04:44:49 mysqld restarted 050914 4:44:53 InnoDB: Started /myProgs/mysql/libexec/mysqld: ready for connections. Version: '4.0.20-log' socket: '/tmp/mysql.sock' port: 3306 050918 0:27:35 Aborted connection 30 to db: 'unconnected' user: 'luke' host: `loc alhost' (Got timeout reading communication packets) 050923 9:01:48 Aborted connection 5931 to db: 'unconnected' user: 'luke' host: `l ocalhost' (Got an error reading communication packets) 050923 9:01:48 Aborted connection 5934 to db: 'unconnected' user: 'luke' host: `l ocalhost' (Got an error reading communication packets) 050923 9:01:48 Aborted connection 5937 to db: 'unconnected' user: 'luke' host: `l ocalhost' (Got an error reading communication packets) 050923 9:01:48 Aborted connection 5940 to db: 'unconnected' user: 'luke' host: `l ocalhost' (Got an error reading communication packets) 050923 9:01:48 Aborted connection 5943 to db: 'unconnected' user: 'luke' host: `l ocalhost' (Got an error reading communication packets) 050923 9:01:48 Aborted connection 5946 to db: 'unconnected' user: 'luke' host: `l ocalhost' (Got an error reading communication packets) 051015 14:53:20 Aborted connection 14332 to db: 'comstechIntDB' user: 'luke' host: / = `localhost' (Got an error writing communication packets) 051019 11:36:44 mysqld started 051019 11:36:44 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 6648179 InnoDB: Doing recovery: scanned up to log sequence number 0 6648179 InnoDB: Last MySQL binlog file position 0 5263271, file name ./bench-bin.015 051019 11:36:44 InnoDB: Flushing modified pages from the buffer pool... 051019 11:36:44 InnoDB: Started /myProgs/mysql/libexec/mysqld: ready for connections. Version: '4.0.20-log' socket: '/tmp/mysql.sock' port: 3306 051019 14:04:27 mysqld started 051019 14:04:27 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 6648179 InnoDB: Doing recovery: scanned up to log sequence number 0 6648179 InnoDB: Last MySQL binlog file position 0 5263271, file name ./bench-bin.015 051019 14:04:27 InnoDB: Flushing modified pages from the buffer pool... 051019 14:04:27 InnoDB: Started
Re: database won't load after machine reboot
Hi David. Thanks for your help. Logan, David (SST - Adelaide) wrote: Hi Luke, Have you tried doing another GRANT statement to ensure the name and password are indeed correct? That would be my next step. That way at least you are sure that the name/password combination are correct. I can't access the database as root anymore. Accessing as other users doesn't allow me to set any GRANT statements. Is there any way I can reset the root password? (Ouch). Kr. Luke. -- Luke -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: database won't load after machine reboot
Hi Luke, Yep, there is a procedure in the manual http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html here. This has all the steps you will need to get root back. Hope it all ends up ok! Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Luke Vanderfluit [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 October 2005 12:17 PM To: mysql Subject: Re: database won't load after machine reboot Hi David. Thanks for your help. Logan, David (SST - Adelaide) wrote: Hi Luke, Have you tried doing another GRANT statement to ensure the name and password are indeed correct? That would be my next step. That way at least you are sure that the name/password combination are correct. I can't access the database as root anymore. Accessing as other users doesn't allow me to set any GRANT statements. Is there any way I can reset the root password? (Ouch). Kr. Luke. -- Luke -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: database won't load after machine reboot
Hi David. Logan, David (SST - Adelaide) wrote: Hi Luke, Yep, there is a procedure in the manual http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html here. This has all the steps you will need to get root back. Hope it all ends up ok! That went well (resetting the root password). Then the grant statement did the trick. Thanks. Kind regards. Luke. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Luke Vanderfluit [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 October 2005 12:17 PM To: mysql Subject: Re: database won't load after machine reboot Hi David. Thanks for your help. Logan, David (SST - Adelaide) wrote: Hi Luke, Have you tried doing another GRANT statement to ensure the name and password are indeed correct? That would be my next step. That way at least you are sure that the name/password combination are correct. I can't access the database as root anymore. Accessing as other users doesn't allow me to set any GRANT statements. Is there any way I can reset the root password? (Ouch). Kr. Luke. -- Luke