Here's the last couple of items from the error log.:
Number of processes running now: 0
030707 21:03:37 mysqld restarted
030707 21:03:37 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence
This is probably a dead horse but let me post a followup to let everyone
know what I did and what has happened since. Maybe I should list it
under some other error number.
Before Paul posted his message I uninstalled (using rpm -e) version
4.0.13. I then got the RedHat installation CDs and
Hi Kevin,
In this case the error log file (hostname.err) in f.e /var/lib/mysql should
give you an idea whats going on.
Perhaps the settings inside the my.cnf from the newer version are very
different then from the older version.
Best regards
Nils Valentin
Tokyo/Japan
2003 7 10
Kevin H. Phillips [EMAIL PROTECTED] wrote:
Hi, Nils
I was able to stop the mysqld daemon using the kill command. However,
when I tried to start it using mysqld_safe --skip-grant-tables, a line
would appear saying:
[EMAIL PROTECTED] root]# mysqld_safe --skip-grant-tables
Starting mysqld
At 10:35 +0900 7/7/03, Nils Valentin wrote:
2003îN 7åé 7ì åéójì 10:28ÅANils Valentin ÇÇÒÇÕèëÇ´ÇÐǵÇ:
Hi Kevin,
try this:
1) stop the mysql server
2) mysqld_safe --skip-grant-tables
3) mysql -u root
4) mysql SHOW GRANTS FOR root;
5) GRANT ALL ON *.* TO 'root'@'%';
GRANT ALL ON *.* TO
Hi Paul,
A good lesson to learn ;-).
What you are saying actually means that Kevin didnt need to install it again.
I must have missed this part in the manual.
Thank you for pointing this out.
Best regards
Nils Valentin
Tokyo/Japan
2003 7 9 11:14Paul DuBois :
At 10:35 +0900 7/7/03, Nils
Hi, Nils
I was able to stop the mysqld daemon using the kill command. However,
when I tried to start it using mysqld_safe --skip-grant-tables, a line
would appear saying:
[EMAIL PROTECTED] root]# mysqld_safe --skip-grant-tables
Starting mysqld daemon with databases from /var/lib/mysql
with the
Hi Kevin;
Try to start it as
mysqld_safe --skip-grant-tables
to start the service in the background, you will then be able to continue in
the same window. Sorry I didn't mention this.
Can you post the grant command you try exactly as it is to the mailing list
please (without password of
Hi, Nils
OK, here's a copy of the terminal screen I am getting after killing the
mysqld daemon and then re-starting it:
[EMAIL PROTECTED] root]# ps ax |grep mysqld
32309 pts/0S 0:00 /bin/sh /usr/bin/mysqld_safe --skip-grant-tables
32334 pts/0S 0:00 /usr/libexec/mysqld
2003 7 8 10:25Kevin H. Phillips :
Hi, Nils
OK, here's a copy of the terminal screen I am getting after killing the
mysqld daemon and then re-starting it:
[EMAIL PROTECTED] root]# ps ax |grep mysqld
32309 pts/0S 0:00 /bin/sh /usr/bin/mysqld_safe --skip-grant-tables
32334 pts/0S
Hi, Nils
Here's what I get:
mysql GRANT ALL ON *.* TO '[EMAIL PROTECTED]' IDENTIFIED BY 'password'
WITH GRANT OPTION;
ERROR 1047: Unknown command
mysql
I'm sorry I should have asked before if the apostrophes were necessary.
And, the first one is an apostrophe and not the little tilted
Forgot to mention that I installed from an rpm. I rebuilt a source rpm.
Kevin
Nils Valentin wrote:
How did you install the mysql server (rpm or tar.gz ) ?
Best regards
Nils Valentin
Tokyo/Japan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
2003 7 8 11:40Kevin H. Phillips :
Hi, Nils
I just thought that it would be better, more particularized, for my
system. Would it be better to use the precompiled rpms?
Generally talking I believe you can avoid some trouble by using the provided
rpm binary packages. However, I guess that for
Hi Kevin,
try this:
1) stop the mysql server
2) mysqld_safe --skip-grant-tables
3) mysql -u root
4) mysql SHOW GRANTS FOR root;
5) GRANT ALL ON *.* TO 'root'@'%';
6) restart the server (without --skip-grant-table option) and try to login
Best regards
Nils Valentin
Tokyo/Japan
2003 7 5
2003 7 7 10:28Nils Valentin :
Hi Kevin,
try this:
1) stop the mysql server
2) mysqld_safe --skip-grant-tables
3) mysql -u root
4) mysql SHOW GRANTS FOR root;
5) GRANT ALL ON *.* TO 'root'@'%';
GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY 'secret' WITH GRANT OPTION;
sorry for the
Hi, Nils
I can't get the mysql server to stop! If I try service mysqld stop I
get a FAILED error. If I try mysqladmin -u root -p shutdown, I get:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)'
[EMAIL PROTECTED]
Hi Kevin,
There is a way to sop the server on OS level. However I am not sure if you
want to do it this way. You can use the kill command, but be aware that it
might damage a data file if the database is accessing it in just this moment.
Having said this warning, here is what you can do:
1)
Kevin H. Phillips [EMAIL PROTECTED] wrote:
I am trying to set up mysql 4.0.13 on my RedHat 9 machine. I rebuilt
the source rpm. (I had a previous installation which I deleted first).
I can log on to the mysql monitor as root but can't creat databases,
can't change passwords, can't grant
Here's what I get:
mysql SELECT USER();
++
| USER() |
++
| [EMAIL PROTECTED] |
++
1 row in set (0.02 sec)
mysql
Kevin
Victoria Reznichenko wrote:
What is the output of SELECT USER()?
--
MySQL General Mailing List
For list archives:
I am trying to set up mysql 4.0.13 on my RedHat 9 machine. I rebuilt
the source rpm. (I had a previous installation which I deleted first).
I can log on to the mysql monitor as root but can't creat databases,
can't change passwords, can't grant privileges, can't select hosts,
can't seem to do
20 matches
Mail list logo