Re: mysql admin user problem
I can tell you why the purge worked. It destroyed your corrupted MySQL user database. :) At 04:42 PM 7/08/03 -0600, David Wilk wrote: >Howdy all, just wanted to say what worked. Dominik's suggestion to >'purge' the mysql packages with apt-get did the trick. One final >reinstall had everything working fine. Not sure where the sanfu was... -- REMEMBER THE WORLD TRADE CENTER ---=< WTC 911 >=-- "...ne cede males" 0100
Re: mysql admin user problem
I can tell you why the purge worked. It destroyed your corrupted MySQL user database. :) At 04:42 PM 7/08/03 -0600, David Wilk wrote: >Howdy all, just wanted to say what worked. Dominik's suggestion to >'purge' the mysql packages with apt-get did the trick. One final >reinstall had everything working fine. Not sure where the sanfu was... -- REMEMBER THE WORLD TRADE CENTER ---=< WTC 911 >=-- "...ne cede males" 0100 -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: mysql admin user problem
Howdy all, just wanted to say what worked. Dominik's suggestion to 'purge' the mysql packages with apt-get did the trick. One final reinstall had everything working fine. Not sure where the sanfu was... thanks guys! On Mon, Jun 30, 2003 at 05:03:36PM -0600 or thereabouts, David Wilk wrote: > Howdy folks, > > I have installed mysql a few times (from debian packages) and never had > any trouble, but this one just stumpes me. I installed debian woody and > mysql on a server. I screwed up /var/lib/mysql trying to copy over some > databases so I reinstalled mysql to bring things back to normal. I > removed /var/lib/mysql first of course, but once installed, I would get > this error when trying to start mysql: > > > Starting MySQL database server: mysqld...failed. > > > cat /var/log/mysql/mysql.err gives: > > > 030630 16:59:46 mysqld started > /usr/sbin/mysqld: ready for connections > > > but, cat /var/log/mysql.log gives: > > > /usr/sbin/mysqld, Version: 3.23.49-log, started with: > Tcp port: 0 Unix socket: /var/run/mysqld/mysqld.sock > Time Id CommandArgument > 030630 16:59:47 1 Connect Access denied for user: > '[EMAIL PROTECTED]' (Using password: YES) > 030630 16:59:48 2 Connect Access denied for user: > '[EMAIL PROTECTED]' (Using password: YES) > 030630 16:59:49 3 Connect Access denied for user: > '[EMAIL PROTECTED]' (Using password: YES) > 030630 16:59:50 4 Connect Access denied for user: > '[EMAIL PROTECTED]' (Using password: YES) > 030630 16:59:51 5 Connect Access denied for user: > '[EMAIL PROTECTED]' (Using password: YES) > 030630 16:59:52 6 Connect Access denied for user: > '[EMAIL PROTECTED]' (Using password: YES) > > > The process list shows 4 mysql processes running (when none were running > before). '/etc/init.d/mysql stop' does nothing. > > I have removed mysql-server, and mysql-client and then removed > /etc/mysql and /var/lib/mysql before reinstalling both mysql-server and > mysql-client. yet, still I get these errors. > > if anyone has any ideas I'd love to hear them! > > thanks, > Dave > > > -- > *** > David Wilk > System Administrator > Community Internet Access, Inc. > [EMAIL PROTECTED] > > > -- > To UNSUBSCRIBE, email to [EMAIL PROTECTED] > with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED] > -- *** David Wilk System Administrator Community Internet Access, Inc. [EMAIL PROTECTED]
Re: mysql admin user problem
Howdy all, just wanted to say what worked. Dominik's suggestion to 'purge' the mysql packages with apt-get did the trick. One final reinstall had everything working fine. Not sure where the sanfu was... thanks guys! On Mon, Jun 30, 2003 at 05:03:36PM -0600 or thereabouts, David Wilk wrote: > Howdy folks, > > I have installed mysql a few times (from debian packages) and never had > any trouble, but this one just stumpes me. I installed debian woody and > mysql on a server. I screwed up /var/lib/mysql trying to copy over some > databases so I reinstalled mysql to bring things back to normal. I > removed /var/lib/mysql first of course, but once installed, I would get > this error when trying to start mysql: > > > Starting MySQL database server: mysqld...failed. > > > cat /var/log/mysql/mysql.err gives: > > > 030630 16:59:46 mysqld started > /usr/sbin/mysqld: ready for connections > > > but, cat /var/log/mysql.log gives: > > > /usr/sbin/mysqld, Version: 3.23.49-log, started with: > Tcp port: 0 Unix socket: /var/run/mysqld/mysqld.sock > Time Id CommandArgument > 030630 16:59:47 1 Connect Access denied for user: > '[EMAIL PROTECTED]' (Using password: YES) > 030630 16:59:48 2 Connect Access denied for user: > '[EMAIL PROTECTED]' (Using password: YES) > 030630 16:59:49 3 Connect Access denied for user: > '[EMAIL PROTECTED]' (Using password: YES) > 030630 16:59:50 4 Connect Access denied for user: > '[EMAIL PROTECTED]' (Using password: YES) > 030630 16:59:51 5 Connect Access denied for user: > '[EMAIL PROTECTED]' (Using password: YES) > 030630 16:59:52 6 Connect Access denied for user: > '[EMAIL PROTECTED]' (Using password: YES) > > > The process list shows 4 mysql processes running (when none were running > before). '/etc/init.d/mysql stop' does nothing. > > I have removed mysql-server, and mysql-client and then removed > /etc/mysql and /var/lib/mysql before reinstalling both mysql-server and > mysql-client. yet, still I get these errors. > > if anyone has any ideas I'd love to hear them! > > thanks, > Dave > > > -- > *** > David Wilk > System Administrator > Community Internet Access, Inc. > [EMAIL PROTECTED] > > > -- > To UNSUBSCRIBE, email to [EMAIL PROTECTED] > with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED] > -- *** David Wilk System Administrator Community Internet Access, Inc. [EMAIL PROTECTED] -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: mysql admin user problem
Actually this is a very common problem. Either mysql doesn't know about a user called "debian-sys-maint" or it doesn't have localhost permission. Mysql has it's own user db independant of the system. You'll need to go into mysql command prompt as root and do a GRANT to create debian-sys-maint and give it whatever access you want it to have. These permissions are host specific so user@'anywhere' is not the same as [EMAIL PROTECTED], blame the regex. If you already fiddled around with this and it still doesn't work then destroy any references to the user with some REVOKE's or manually beat the db entry and start over. This prob is actually well documented in the MySQL html manual. At 09:42 AM 7/01/03 +0200, [EMAIL PROTECTED] wrote: >> Tcp port: 0 Unix socket: /var/run/mysqld/mysqld.sock >> Time Id CommandArgument >> 030630 16:59:47 1 Connect Access denied for user: >> '[EMAIL PROTECTED]' (Using password: YES) -- REMEMBER THE WORLD TRADE CENTER ---=< WTC 911 >=-- "...ne cede males" 0100
Re: mysql admin user problem
Actually this is a very common problem. Either mysql doesn't know about a user called "debian-sys-maint" or it doesn't have localhost permission. Mysql has it's own user db independant of the system. You'll need to go into mysql command prompt as root and do a GRANT to create debian-sys-maint and give it whatever access you want it to have. These permissions are host specific so user@'anywhere' is not the same as [EMAIL PROTECTED], blame the regex. If you already fiddled around with this and it still doesn't work then destroy any references to the user with some REVOKE's or manually beat the db entry and start over. This prob is actually well documented in the MySQL html manual. At 09:42 AM 7/01/03 +0200, [EMAIL PROTECTED] wrote: >> Tcp port: 0 Unix socket: /var/run/mysqld/mysqld.sock >> Time Id CommandArgument >> 030630 16:59:47 1 Connect Access denied for user: >> '[EMAIL PROTECTED]' (Using password: YES) -- REMEMBER THE WORLD TRADE CENTER ---=< WTC 911 >=-- "...ne cede males" 0100 -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: mysql admin user problem
I have had a similar problem some time ago, too. I succeded by purging* the mysql-packages before reinstalling them. The reason why you can't stop the mysql-server is obvious: The debian-sys-maint user can't login so the init-script which utilizes this mysql-user can't shutdown the server. * "apt-get --purge remove mysql-server mysql-common" (I don't know if it's necessary to remove mysql-common, too) David Wilk <[EMAIL PROTECTED]> wrote on Mon, 30 Jun 2003 17:03:36 -0600: > Howdy folks, > > I have installed mysql a few times (from debian packages) and never had > any trouble, but this one just stumpes me. I installed debian woody and > mysql on a server. I screwed up /var/lib/mysql trying to copy over some > databases so I reinstalled mysql to bring things back to normal. I > removed /var/lib/mysql first of course, but once installed, I would get > this error when trying to start mysql: > > > Starting MySQL database server: mysqld...failed. > > > cat /var/log/mysql/mysql.err gives: > > > 030630 16:59:46 mysqld started > /usr/sbin/mysqld: ready for connections > > > but, cat /var/log/mysql.log gives: > > > /usr/sbin/mysqld, Version: 3.23.49-log, started with: > Tcp port: 0 Unix socket: /var/run/mysqld/mysqld.sock > Time Id CommandArgument > 030630 16:59:47 1 Connect Access denied for user: > '[EMAIL PROTECTED]' (Using password: YES) > 030630 16:59:48 2 Connect Access denied for user: > '[EMAIL PROTECTED]' (Using password: YES) > 030630 16:59:49 3 Connect Access denied for user: > '[EMAIL PROTECTED]' (Using password: YES) > 030630 16:59:50 4 Connect Access denied for user: > '[EMAIL PROTECTED]' (Using password: YES) > 030630 16:59:51 5 Connect Access denied for user: > '[EMAIL PROTECTED]' (Using password: YES) > 030630 16:59:52 6 Connect Access denied for user: > '[EMAIL PROTECTED]' (Using password: YES) > > > The process list shows 4 mysql processes running (when none were running > before). '/etc/init.d/mysql stop' does nothing. > > I have removed mysql-server, and mysql-client and then removed > /etc/mysql and /var/lib/mysql before reinstalling both mysql-server and > mysql-client. yet, still I get these errors. > > if anyone has any ideas I'd love to hear them! > > thanks, > Dave > > > -- > *** > David Wilk > System Administrator > Community Internet Access, Inc. > [EMAIL PROTECTED] > > > -- > To UNSUBSCRIBE, email to [EMAIL PROTECTED] > with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED] Mit freundlichen Gruessen / Best regards Dominik Schulz
Re: mysql admin user problem
I have had a similar problem some time ago, too. I succeded by purging* the mysql-packages before reinstalling them. The reason why you can't stop the mysql-server is obvious: The debian-sys-maint user can't login so the init-script which utilizes this mysql-user can't shutdown the server. * "apt-get --purge remove mysql-server mysql-common" (I don't know if it's necessary to remove mysql-common, too) David Wilk <[EMAIL PROTECTED]> wrote on Mon, 30 Jun 2003 17:03:36 -0600: > Howdy folks, > > I have installed mysql a few times (from debian packages) and never had > any trouble, but this one just stumpes me. I installed debian woody and > mysql on a server. I screwed up /var/lib/mysql trying to copy over some > databases so I reinstalled mysql to bring things back to normal. I > removed /var/lib/mysql first of course, but once installed, I would get > this error when trying to start mysql: > > > Starting MySQL database server: mysqld...failed. > > > cat /var/log/mysql/mysql.err gives: > > > 030630 16:59:46 mysqld started > /usr/sbin/mysqld: ready for connections > > > but, cat /var/log/mysql.log gives: > > > /usr/sbin/mysqld, Version: 3.23.49-log, started with: > Tcp port: 0 Unix socket: /var/run/mysqld/mysqld.sock > Time Id CommandArgument > 030630 16:59:47 1 Connect Access denied for user: > '[EMAIL PROTECTED]' (Using password: YES) > 030630 16:59:48 2 Connect Access denied for user: > '[EMAIL PROTECTED]' (Using password: YES) > 030630 16:59:49 3 Connect Access denied for user: > '[EMAIL PROTECTED]' (Using password: YES) > 030630 16:59:50 4 Connect Access denied for user: > '[EMAIL PROTECTED]' (Using password: YES) > 030630 16:59:51 5 Connect Access denied for user: > '[EMAIL PROTECTED]' (Using password: YES) > 030630 16:59:52 6 Connect Access denied for user: > '[EMAIL PROTECTED]' (Using password: YES) > > > The process list shows 4 mysql processes running (when none were running > before). '/etc/init.d/mysql stop' does nothing. > > I have removed mysql-server, and mysql-client and then removed > /etc/mysql and /var/lib/mysql before reinstalling both mysql-server and > mysql-client. yet, still I get these errors. > > if anyone has any ideas I'd love to hear them! > > thanks, > Dave > > > -- > *** > David Wilk > System Administrator > Community Internet Access, Inc. > [EMAIL PROTECTED] > > > -- > To UNSUBSCRIBE, email to [EMAIL PROTECTED] > with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED] Mit freundlichen Gruessen / Best regards Dominik Schulz -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
mysql admin user problem
Howdy folks, I have installed mysql a few times (from debian packages) and never had any trouble, but this one just stumpes me. I installed debian woody and mysql on a server. I screwed up /var/lib/mysql trying to copy over some databases so I reinstalled mysql to bring things back to normal. I removed /var/lib/mysql first of course, but once installed, I would get this error when trying to start mysql: Starting MySQL database server: mysqld...failed. cat /var/log/mysql/mysql.err gives: 030630 16:59:46 mysqld started /usr/sbin/mysqld: ready for connections but, cat /var/log/mysql.log gives: /usr/sbin/mysqld, Version: 3.23.49-log, started with: Tcp port: 0 Unix socket: /var/run/mysqld/mysqld.sock Time Id CommandArgument 030630 16:59:47 1 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 030630 16:59:48 2 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 030630 16:59:49 3 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 030630 16:59:50 4 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 030630 16:59:51 5 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 030630 16:59:52 6 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) The process list shows 4 mysql processes running (when none were running before). '/etc/init.d/mysql stop' does nothing. I have removed mysql-server, and mysql-client and then removed /etc/mysql and /var/lib/mysql before reinstalling both mysql-server and mysql-client. yet, still I get these errors. if anyone has any ideas I'd love to hear them! thanks, Dave -- *** David Wilk System Administrator Community Internet Access, Inc. [EMAIL PROTECTED]
mysql admin user problem
Howdy folks, I have installed mysql a few times (from debian packages) and never had any trouble, but this one just stumpes me. I installed debian woody and mysql on a server. I screwed up /var/lib/mysql trying to copy over some databases so I reinstalled mysql to bring things back to normal. I removed /var/lib/mysql first of course, but once installed, I would get this error when trying to start mysql: Starting MySQL database server: mysqld...failed. cat /var/log/mysql/mysql.err gives: 030630 16:59:46 mysqld started /usr/sbin/mysqld: ready for connections but, cat /var/log/mysql.log gives: /usr/sbin/mysqld, Version: 3.23.49-log, started with: Tcp port: 0 Unix socket: /var/run/mysqld/mysqld.sock Time Id CommandArgument 030630 16:59:47 1 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 030630 16:59:48 2 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 030630 16:59:49 3 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 030630 16:59:50 4 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 030630 16:59:51 5 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 030630 16:59:52 6 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) The process list shows 4 mysql processes running (when none were running before). '/etc/init.d/mysql stop' does nothing. I have removed mysql-server, and mysql-client and then removed /etc/mysql and /var/lib/mysql before reinstalling both mysql-server and mysql-client. yet, still I get these errors. if anyone has any ideas I'd love to hear them! thanks, Dave -- *** David Wilk System Administrator Community Internet Access, Inc. [EMAIL PROTECTED] -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]