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 re
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:
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
apostr
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 --basedir=
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, 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]
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: h
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
The permissions on my /var/lib/mysql directory are: File Owner: mysql
- MySQL Server; Group is mysql.
I did discover that I had not set a user in /etc/my.cnf. Once I did
that, the mysql.sock "file" was set up (doh! sorry about that).
Here's a portion of what I get when I do ls -l /var/lib/m
Well, the find / -name mysql.sock didn't return anything at all so this
*is* an odd predicament. Would it work if someone with a similar
version e-mailed me a copy of their mysql.sock file?
Kevin
>
>
> John Nichel wrote:
It doesn't look as if you have any conflicting MySQL versions. When the
The output of the greps follows. Could it be the mysqlclient that is
causing the trouble?
Kevin
[EMAIL PROTECTED] root]# rpm -qa | grep My
MySQL-python-debuginfo-0.9.1-7
Mysql-DBI-perl-bin-1.1825-1
MySQL-shared-3.23.53a-1
qt-MySQL-3.1.1-6
MySQL-python-0.9.1-7
MyODBC-2.50.39-11
perl-DBD-MySQL-
Yes, I installed by RPM. I have now found the error file as you
mentioned. The output for the last few days is:
030621 06:49:27 mysqld started
030621 6:49:28 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint
I changed the port in /etc/my.cnf and restarted the service but still
get a message that I can't connect to the server, etc.
I am still not seeing any "fresh" log messages. Why would there not be
any output on that? Is there someplace I should look for a log file
besides /var/log ?
Kevin
--
What I'm trying to do is as root user.
Kevin
John Nichel wrote:
Are you trying to stop the server as root, or some other user?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
The output of the grep is:
[EMAIL PROTECTED] root]# ps -ax | grep mysqld
4578 ?S 0:00 /bin/sh /usr/bin/mysqld_safe
--defaults-file=/etc/my.cnf
4601 ?S 0:01 /usr/libexec/mysqld
--defaults-file=/etc/my.cnf --basedir=/usr --datadir=/var/lib/mysql
--user=mysql --pid-file
Yes, the server is running. One odd thing about my setup is that when I
restart the service I get a "Failed" signal for the shutdown phase but
an "OK" for the start phase.
Thanks,
Kevin
Victor Pendleton wrote:
Is the mysql server currently running? You can also use either -S or
--socket to spe
I apologize for posting about something which has probably been covered
before but I can't remember where I have seen this dealt with. I have
been trying to upgrade/install/re-install MySQL 4.0.13 and when I try to
do any administrative work (set root password, for example) I get this
message:
Thanks for the notes. I have gotten the correct my.cnf file in place
now. Now when I try to put in the password for the root user I get this:
$ mysqladmin -u root password 'mypassword'
mysqladmin: unable to change password; error: 'Access denied for user:
'@localhost' to database 'mysql''
(I
I had MySQL 3.23.56 on my RedHat machine but developed some problems
(that were probably my own fault) so I decided to upgrade to 4.0. I
downloaded the source rpm and rebuilt it on my system (running a fully
updated RedHat 9.0). I removed the old mysql by doing rpm -e on the
components; the
Hello,
I just joined the list. I was trying to rebuild the MySQL 4.0.13 source
RPM on my RedHat 9.0 machine. I get the following error messages at the
end:
make[2]: *** [isamchk] Error 1
make[2]: Leaving directory `/usr/src/redhat/BUILD/mysql-4.0.13/isam'
make[1]: *** [all-recursive] Error 1
m
I have mysql working, but I can't get mysqlgui to connect. I've tried the
'bin/mysqladmin version' test and that works ok, it's just that mysqlgui doesnt
connect for some reason. A test doing 'telnet localhost 3306' connects (but later
disconnects, some msg about foreign host...), I just don'
22 matches
Mail list logo
