| View previous topic :: View next topic |
| Author |
Message |
notbob
Guest
|
 Posted: Mon Nov 17, 2008 7:21 am Post subject: I've hosed mysql |
 |
|
I tried the comp.database.mysql group, but they are apparently all at a
mysql convention with no internet access, so.....
OK, history up till know. I ran mysql a couple yrs ago, but had to bail cuz
of family probs. I'm now back into it and seemed to have hose my mysqld
completely. I did the initial steps a couple mos ago and again got
sidetracked and had to come back and forgot all passwds. Tried to reset
root passwd, but didn't work. Removed and reloaded mysql pkg and still no
joy. I've been flogging it for 2 days and have no idea where to go at this
point. I'm using mysql 5.0 on slackware 12.1.
I've done the reset root passwd thing as follows:
pkill mysqld
mysqld_safe --skip-grant-tables &
mysql -u root mysql
UPDATE user SET password=PASSWORD("ualue=42") WHERE user="root";
FLUSH PRIVILEGES;
.....Stop MySQL safe daemon
.....Start MySQL daemon
mysql -u root -p mysql
.....nothing!
I've done above several times, no joy, so that's when I removed/reloaded
mysql. Now, upon new mysql pkg install I had to do no prelim setup cuz
apparently some files still remained and I'm now getting mysqld_safe
everytime I boot up and pkill no longer kills it, I gotta kill -9 to kill
it.
ps aux | grep mysql
root 2588 0.0 0.3 2548 1244 ? S 09:48 0:00 /bin/sh
/usr/bin/mysqld_safe --datadir=/var/lib/mysql
--pid-file=/var/run/mysql/mysql.pid --skip-networking
mysql 2616 0.0 3.4 66068 10748 ? Sl 09:48 0:00
/usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql
--pid-file=/var/run/mysql/mysql.pid --skip-external-locking --skip-networking
I haven't a clue about what to do. Can someone help me untangle this or
wipe slate clean and start over?
nb |
|
| |
|
 Back to top |
Res
Guest
|
| Posted: Mon Nov 17, 2008 7:21 am Post subject: Re: I've hosed mysql |
|
|
On Mon, 17 Nov 2008, notbob wrote:
| Quote: | I tried the comp.database.mysql group, but they are apparently all at a
mysql convention with no internet access, so.....
|
*looks over in cdm* I see only one post of yours and it was dated 4 hours
earlier than this one...
| Quote: | I've done above several times, no joy, so that's when I removed/reloaded
mysql. Now, upon new mysql pkg install I had to do no prelim setup cuz
apparently some files still remained and I'm now getting mysqld_safe
|
So, you have a database you need to keep? if not remove mysql package,
remove the directory /var/lib/mysql, rename /etc/my.cnf to mycnf.bak
try reinstall mysql then run 'mysql_install_db --user=mysql ' then
'mysql_secure_installation'
If you have a database you need to keep, cp /var/lib/mysql/db_name /tmp
then do above, one you can safely log-in, shutdown mysql. cp db back into
place, chown to mysql.mysql and restart, yes you'll have to reset up your
permission again for that DB, but that's no big deal.
--
Res
If you are not part of the solution, then you are part of the problem!
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean. |
|
| |
|
| Back to top |
No_One
Guest
|
| Posted: Mon Nov 17, 2008 8:37 am Post subject: Re: I've hosed mysql |
|
|
On 2008-11-17, notbob <notbob@nothome.com> wrote:
| Quote: | I tried the comp.database.mysql group, but they are apparently all at a
mysql convention with no internet access, so.....
OK, history up till know. I ran mysql a couple yrs ago, but had to bail cuz
of family probs. I'm now back into it and seemed to have hose my mysqld
completely. I did the initial steps a couple mos ago and again got
sidetracked and had to come back and forgot all passwds. Tried to reset
root passwd, but didn't work. Removed and reloaded mysql pkg and still no
joy. I've been flogging it for 2 days and have no idea where to go at this
point. I'm using mysql 5.0 on slackware 12.1.
I've done the reset root passwd thing as follows:
pkill mysqld
mysqld_safe --skip-grant-tables &
mysql -u root mysql
UPDATE user SET password=PASSWORD("ualue=42") WHERE user="root";
FLUSH PRIVILEGES;
....Stop MySQL safe daemon
....Start MySQL daemon
mysql -u root -p mysql
....nothing!
I've done above several times, no joy, so that's when I removed/reloaded
mysql. Now, upon new mysql pkg install I had to do no prelim setup cuz
apparently some files still remained and I'm now getting mysqld_safe
everytime I boot up and pkill no longer kills it, I gotta kill -9 to kill
it.
|
Did you stop mysql before you ran the package uninstall??
Stop mysql, run uninstall then check the uninstall script and manually
delete all the files listed in the script. Make sure you delete the mysql
database as well. Make sure you delete any mysql files in any user account,
sometimes, mysql.conf is stored in a user account...whatever the config file
is called.
Rerun your updatedb then check for any mysql files that might be around.
Now use package tool to reinstall mysql and follow the setup procedures.
Can't image why you might be having a problem
ken |
|
| |
|
| Back to top |
|
