Assuming Linux, check where it's listening using "netstat -lptn".
lx wrote:
>hi all:
>I'm a new one. I have a mysql server in 192.168.27.72 , and a mysql
>client in 192.168.23.73.
>I use this way:
> mysql -h 192.168.27.72 -u root -p
>
>the ERROR messa
hi all:
I'm a new one. I have a mysql server in 192.168.27.72 , and a mysql
client in 192.168.23.73.
I use this way:
mysql -h 192.168.27.72 -u root -p
the ERROR message is:
ERROR 2003 (HY000): Can't connect to MySQL server on '192.
On 5/12/2005 11:56 a.m., Mike Smith wrote:
Hi,
Hi,
I've already check my /etc/my.cnf file for a "binding"
line. Its not
there. I also found an item online that indicated
adding:
Look for the option "skip-networking". This disables TCP/IP so the
server only accepts local connections v
qldump on mythconverg and install
Mandrivia 2006 on
server gandalf. I restored the mythconverg; Now, I
get:
[EMAIL PROTECTED] mysql -u mythtv -pmythtv -h gandalf
mythconverg
ERROR 2003 (HY000): Can't connect to MySQL server on
'gandalf' (111)
I then tried granting privledges to
server A and mysql 4.0 on server B. Starting
> >
> > mycompA$>mysql -h mycompB -u mysql -p
> >
> > on host A, I can connect and to the mysql-server on host B. However when
> > I start
> >
> > mycompB$>mysql -h mycompA -u mysql -p
> >
> > on
te:
Hi,
I installed mysql 5.0 on server A and mysql 4.0 on server B. Starting
mycompA$>mysql -h mycompB -u mysql -p
on host A, I can connect and to the mysql-server on host B. However when I
start
mycompB$>mysql -h mycompA -u mysql -p
on host B, I get the error message:
ERROR 2003:
Hi,
I installed mysql 5.0 on server A and mysql 4.0 on server B. Starting
mycompA$>mysql -h mycompB -u mysql -p
on host A, I can connect and to the mysql-server on host B. However when I
start
mycompB$>mysql -h mycompA -u mysql -p
on host B, I get the error message:
ERROR 2003:
\mysql\bin>mysql
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)
My my.ini file
# Example mysql config file.
# Copy this file to c:\my.cnf to set global options
#
# One can use all long options that the program supports.
# Run the program with --help to get a
Hi All:
I am trying to run mysql in a Windows XP environment. I downloaded the
binary and installation went smoothly. What I am expecting is that if I
have winmysqladmin in my startup it should launch and I should be able to
connect using the mysql control centre as my client. So far no joy.
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
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日 木曜日 11:
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
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:14、Paul DuBois さんは書きました:
> At 10:35 +0900 7/
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
"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
2003年 7月 8日 火曜日 11:40、Kevin 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,
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
2003年 7月 8日 火曜日 10:25、Kevin 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-tabl
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 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 c
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,
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) ps
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]
getting Errors 1044 & 2003. Here's some of the output:
> > >
> > > [EMAIL PROTECTED] root]# mysql -u root mysql
> > > Welcome to the MySQL monitor. Commands end with ; or \g.
> > > Your MySQL connection id is 19 to server version: 4.0.13-log
> > &g
#x27;\c' to clear the buffer.
> >
> > mysql> CREATE DATABASE ;
> > ERROR 1044: Access denied for user: '@localhost' to database
> > '' mysql> \q
> > Bye
> > [EMAIL PROTECTED] root]# mysql -u root -h 127.0.0.1
> > ERROR 2003: C
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
monitor. Commands end with ; or \g.
> Your MySQL connection id is 19 to server version: 4.0.13-log
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> CREATE DATABASE ;
> ERROR 1044: Access denied for user: '@localhost
; or '\h' for help. Type '\c' to clear the buffer.
mysql> CREATE DATABASE ;
ERROR 1044: Access denied for user: '@localhost' to database ''
mysql> \q
Bye
[EMAIL PROTECTED] root]# mysql -u root -h 127.0.0.1
ERROR 2003: Can't connect to MySQL s
t that
> the mySQL server could resolve the IP to the host name? Thanx!
>
> -Original Message-
> From: O'K Web Design [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 05, 2003 8:06 AM
> To: Francisco Castellon
> Subject: Re: ERROR 2003: Can't connect to MySQL ser
ave to add the IP address as an allowed host though, but I thought that
the mySQL server could resolve the IP to the host name? Thanx!
-Original Message-
From: O'K Web Design [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 05, 2003 8:06 AM
To: Francisco Castellon
Subject: Re: ERROR 2003
mySQL server using the [EMAIL PROTECTED]
account?
Also I was trying to access the mySQL server using the root@
HOST.MYDOMAIN.COM account by using the command below:
Shell> mysql -u root -h ZEUS.OLYMPUS.LOCAL -p
Enter Password: ***
And this is what I get: ERROR 2003: Can't connect
OTECTED]
account?
Also I was trying to access the mySQL server using the root@
HOST.MYDOMAIN.COM account by using the command below:
Shell> mysql -u root -h ZEUS.OLYMPUS.LOCAL -p
Enter Password: ***
And this is what I get: ERROR 2003: Can't connect to MySQL server on
'ZEUS.
] account?
Also I was trying to access the mySQL server using the root@ HOST.MYDOMAIN.COM account
by using the command below:
Shell> mysql –u root –h ZEUS.OLYMPUS.LOCAL –p
Enter Password: ***
And this is what I get: ERROR 2003: Can't connect to MySQL server on
'ZEUS.OLYMPUS.LOCA
OTECTED]
account?
Also I was trying to access the mySQL server using the root@
HOST.MYDOMAIN.COM account by using the command below:
Shell> mysql -u root -h ZEUS.OLYMPUS.LOCAL -p
Enter Password: ***
And this is what I get: ERROR 2003: Can't connect to MySQL server on
'ZEUS.
hi listers
i have a c program that connects to a myssql db. for some reason or another,
every now and again i get the following error message
ERROR in mysql_real_connect()
Number: 2003
Message: Can't connect to MySQL server on 'softdistqa' (10048)
i find enough info on mysql website about
following reason: ERROR 2003: Can't connect to MySQL server on
'localhost' (10061)
After this, I deinstalled both MySQL programs and then installed MySQL
3.23.52 alone. Again, everytime I wanted to start mysql, I got the
message "ERROR 2003: Can't connect to MySQL server on
Hi.
I am new to this and can't get started because I receive the error message:
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061).
o/s : WindowsXP.
Any ideas?
Thanks,
Clive.
-
Before p
Clive Grigg wrote:
> Hi.
> I am new to this and can't get started because I receive the error message:
>
> ERROR 2003: Can't connect to MySQL server on 'localhost' (10061).
>
> o/s : WindowsXP.
>
> Any ideas?
>
> Thanks,
> Clive.
>
Hi,
Problem: mysql & mysqld cannot communicate (error 2003)
Synopsis:
(a) I installed mysql on a Unix SunOS system, but the post-installation died silently
in mysql_install_db. There
were no diagnostic messages. Trial-and-error indicated that mysql_install-db has a bug
(a missing '&&
Hi,
I've been trying to connect remotely to a MySQL server all night on a Linux
machine, to no avail. I'm on a Linux client trying to access MySQL on both an
NT Server and a Linux server. So far I've been able to connect to the NT
server database without a hitch, however every time I tr
Hello,
I am running version 3.23.41 on windows '98. When I run winipcfg I show
that my hostname is siren.goldengate.net and
my ip address is 10.0.0.1. When I type c:\mysql\bin mysql I get an error
message:
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)
I tr
Hi,
Does anyone know how to fix the following error?
"ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)"
I get this by typing "mysql" at the shell prompt (ie C:\mysql\ mysql
[return])
MySQL is installed in the default C:\mysql. I'm runni
Hi, I am getting an
"error 2003 Can't connect MySQL server on Local Host
(10061)"
What does it mean? What should I do?
__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auc
At 22:25 27/02/2001 +, David Murphy wrote:
Hi!
>I have been running MySQL server for four weeks now and have not had any
>problems, until now
>I loaded Windows 2000 Server up this morning and tried to connect to
>mysql...I got the following error
>
>ERROR 2003: Can't
I have been running MySQL server for four weeks now and have not had any
problems, until now
I loaded Windows 2000 Server up this morning and tried to connect to
mysql...I got the following error
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)
>From Component
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To requ
47 matches
Mail list logo