Hello John,
On 9/2/2013 12:49 AM, John Smith wrote:
On Sun, 1/9/13, Reindl Harald h.rei...@thelounge.net wrote:
Subject: Re: Can't Connect Localhost
To: mysql@lists.mysql.com
Date: Sunday, 1 September, 2013, 2:44 PM
I looked
.
In any case, your original error message, although it is a MySQL error, as
Harald said does not look like something straight from MySQL client
(mysql.exe), but something passed through another. What did you enter to get
it?
Note this quote:
The error (2003) Can't connect to MySQL server on 'server
__mysql_exceptions,OperationalError (2003 Can't connect to MySQL server on
'localhost' (10061))
My question: How do I change from localhost to 124.0.0.1?
TIA
John
On Sun, 1/9/13, Terry J Fundak te...@tjsoftworks.com wrote:
Subject: Re: Can't
01.09.2013 13:56, schrieb John Smith:
__mysql_exceptions,OperationalError (2003 Can't connect to MySQL server on
'localhost' (10061))
My question: How do I change from localhost to 124.0.0.1?
Hi John,
Starting over….
What is the error message?
On Aug 31, 2013, at 3:26 PM, John
On Sun, 1/9/13, Reindl Harald h.rei...@thelounge.net wrote:
Subject: Re: Can't Connect Localhost
To: mysql@lists.mysql.com
Date: Sunday, 1 September, 2013, 1:34 PM
where you can change this? typically
in the config file
of teh software without
Am 01.09.2013 15:37, schrieb John Smith:
On Sun, 1/9/13, Reindl Harald h.rei...@thelounge.net wrote:
Subject: Re: Can't Connect Localhost
To: mysql@lists.mysql.com
Date: Sunday, 1 September, 2013, 1:34 PM
where you can change
Try
mysql -u root -h 127.0.0.1 -p
And if that doesn't work
mysql -u root -h PC IP address -p
On Sep 1, 2013, at 4:59 AM, John Smith cantinaderecuer...@yahoo.com wrote:
__mysql_exceptions,OperationalError (2003 Can't connect to MySQL server on
'localhost' (10061))
My question: How do I
On Sun, 1/9/13, Reindl Harald h.rei...@thelounge.net wrote:
Subject: Re: Can't Connect Localhost
To: mysql@lists.mysql.com
Date: Sunday, 1 September, 2013, 2:44 PM
I looked in mysql.config.pl and no localhost :(
mysql.config.pl from what
Hi;
How do I change my connection from localhost to 127.0.0.1 on a Win8 machine?
TIA,
John
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Am 01.09.2013 00:26, schrieb John Smith:
How do I change my connection from localhost to 127.0.0.1 on a Win8 machine?
in which context?
mysql -h 127.0.0.1..
signature.asc
Description: OpenPGP digital signature
first: you not answer off-list on list-repsones
Am 01.09.2013 01:00, schrieb Terry J Fundak:
So... I guess I need to ask: Do you know that 127.0.0.1/localhost only refers
to the machine you are on, right?
naturally yes
One cannot, for example, attempt to login to a remote host with that IP
Am 01.09.2013 01:02, schrieb Terry J Fundak:
Also https://en.wikipedia.org/wiki/Localhost for move reading on the
subject
Sorry if I'm missing your issue
why do you think that i have any issue and why
do you insist to reply offlist?
On Aug 31, 2013, at 15:41, Reindl Harald
Hi John,
Starting over….
What is the error message?
Terry
___
Terry J Fundak
Systems Engineer
Network Design and Security Solutions for SMBs
Tech Support - Client and Server Systems
TJSoftworks
1834 Chadwick Court
Santa Rosa, CA 95401
(707) 849-1000 Cell
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.168.27.72' (111
): Can't connect to MySQL server on '192.168.27.72'
(111)
#
mysql select host, user, password from user;
+-+--+---+
| host| user
socket = /var/run/mysqld/mysqld.sock
root@devel:~# /etc/init.d/mysql restart
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld . . . . . . . . . . . . . .
failed!
root@devel:~# mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't
Il 11/04/2012 10:51, Ganesh Kumar ha scritto:
Hi Guys,
I am using debian squeeze it's working good, I am trying to install
mysql-server. mysql-server installation successfully but didn't start
root@devel:~# /etc/init.d/mysql restart
Stopping MySQL database server: mysqld.
Starting MySQL
.
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
root@devel:~# mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)
root@devel:~# cd /var/run/mysqld/
root@devel:/var/run/mysqld# ls
root
): Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)
root@devel:~# cd /var/run/mysqld/
root@devel:/var/run/mysqld# ls
root@devel:/var/run/mysqld#
Is selinux enabled? If so, check the logs for that.
--
MySQL General Mailing List
For list archives: http
Hi,
All I would like to do is the create a small database with a non-root
user which is allowed to access the db, however after hours of trying
I gave up.
I am using MySQL-5.5.20 on Fedora16 .
CREATE USER 'someone'@'%' IDENTIFIED BY 'somepass';
CREATE DATABASE somedb;
GRANT ALL ON somedb.* TO
Hi Rik,
Have you tried the _full_ user-identification (which is with host)?
GRANT ALL ON somedb.* TO 'someone'@'%';
Yes I had (and just tried to verify) but it didn't help.
Could it be Fedora's mysql packages are special somehow?
Re-installing mysql after deletig its data-directory didn't
Hi Rik,
Have you tried the _full_ user-identification (which is with host)?
GRANT ALL ON somedb.* TO 'someone'@'%';
Yes I had (and just tried to verify) but it didn't help.
Oops, didn't use reply-to-list instead of reply-to-author, my apologies...
Could it be Fedora's mysql
Hi,
1. FLUSH PRIVILEGES is not needed, the SQL commands to manage user and
grants reload automatically the grant tables,
that was used in the very past when people use to tinker directly the grant
tables.
2. you did not specify the @ part of the 'someone' : GRANT ALL ON
somedb.* TO
Hi Rik,
Hm, is the mysql-client library the same as the mysql-server?
Yes.
And does mysql --host=127.0.0.1 --user=someone -p somedb work (or it's actual
IP-address, forcing the TCP/IP connect instead of possible sockets) ?
This is really strange - with -h127.0.0.1 I get the same error:
ERROR
you probably have the anonymous user account taking over: ''@'localhost'
when you specify the host with -h you are actually forcing MySQL to use
TCP/IP so it will authenticate you using your ip address (127.0.0.1)
login as root and:
mysql drop user ''@'localhost';
and try again
Cheers
If you want to verify it is very easy:
$ mysql --user=someone somedb (without -p)
mysql select user(); select current_user();
cheers
Claudio
2012/3/16 Claudio Nanni claudio.na...@gmail.com
you probably have the anonymous user account taking over: ''@'localhost'
when you specify
Hm, is the mysql-client library the same as the mysql-server?
Yes.
Aight...
And does mysql --host=127.0.0.1 --user=someone -p somedb work (or it's
actual IP-address, forcing the TCP/IP connect instead of possible
sockets) ?
This is really strange - with -h127.0.0.1 I get the same
On 3/16/2012 7:00 AM, Clemens Eisserer wrote:
Hi Rik,
Hm, is the mysql-client library the same as the mysql-server?
Yes.
And does mysql --host=127.0.0.1 --user=someone -p somedb work (or it's actual
IP-address, forcing the TCP/IP connect instead of possible sockets) ?
This is really
Hi Claudio,
you probably have the anonymous user account taking over: ''@'localhost'
login as root and:
mysql drop user ''@'localhost';
Thanks a lot, that solved the problem (and saved my day :) !).
when you specify the host with -h you are actually forcing MySQL to use
TCP/IP so it will
Hi Shawn,
I understand the logic behind seperating local and remote users,
postgresql does the same thing in its pg_hba.conf file.
However, what I don't understand is the way this turned out to be such
a huge problem (for me), as it worked already with MySQL-5.1 a few
years ago. I've worked with
Hi Clemens,
my pleasure!
I forgot, you had to use also -P3306, so using both -h and -P which deny
the lookup for users at localhost,
forcing TCP-IP. and so IPs.
this is also good when the socket file is not in the standard location, you
will have the same problem logging in locally,
using -h
On 3/16/2012 2:41 PM, Clemens Eisserer wrote:
Hi Shawn,
I understand the logic behind seperating local and remote users,
postgresql does the same thing in its pg_hba.conf file.
However, what I don't understand is the way this turned out to be such
a huge problem (for me), as it worked already
I have been using my local dictionary for years, accessing from web browser,
pointing to http://localhost:9000/
Probably my fault, since i have been tinkering a little with my settings. As
i try to connect, i get
Can't connect to MySQL server on '127.0.0.1' (111)
Any ideas, what to check
/
Probably my fault, since i have been tinkering a little with my settings. As
i try to connect, i get
Can't connect to MySQL server on '127.0.0.1' (111)
Any ideas, what to check?
I am using linux/opensuse 11.4
signature.asc
Description: OpenPGP digital signature
browser,
pointing to http://localhost:9000/
Probably my fault, since i have been tinkering a little with my settings.
As
i try to connect, i get
Can't connect to MySQL server on '127.0.0.1' (111)
Any ideas, what to check?
I am using linux/opensuse 11.4
Thank you
p
--
MySQL
Andrew Moore wrote:
I think you'll need to give us a bit more to go on. I presume this is a
web based app?
yes
What have you changed? Has the MySQL daemon stopped? What have you
changed?
from 'ps' i get
3545 0.0 0.1 194816 3292 ?Sl 13:58 0:08 /usr/sbin/mysqld --
Reindl Harald wrote:
Did you make any change in the my.cnf?
What does netstat --numeric-hosts --notrim --programs -u -t say?
What is the content of your my.cnf?
Here incluede
thank you
p
--
(xpol) % netstat --numeric-hosts --notrim --programs -u -t
~
please do not only post outputs, read them and try to understand
before press send - not all processes could be identified, non-owned process
info will not be shown, you would have to be root to see it all. in
the ouptput says that all afterwards is useless
netstat --numeric-hosts --notrim
Reindl Harald wrote:
please do not only post outputs, read them and try to understand
before press send - not all processes could be identified, non-owned
process info will not be shown, you would have to be root to see it all.
in the ouptput says that all afterwards is useless
netstat
Please netstat --numeric-hosts --notrim --programs -u -t -l
In my first answer i forgot the -l
Without we get active connections, but we want the listening
tcp-services where somewhere must by mysqld
the easiest test is however
[harry@srv-rhsoft:~]$ telnet 127.0.0.1 3306
Trying 127.0.0.1...
Reindl Harald wrote:
Please netstat --numeric-hosts --notrim --programs -u -t -l
In my first answer i forgot the -l
i will check according to your suggstions
If i find still in troubles, i will let you know
thank you
---p
--
MySQL General Mailing List
For list archives:
hi experts
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
iam facing the above error while connecting the mysql database. i am also
checked the mysql.sock socket file is not in /tmp.
could you please help me to fix this problem. what i have to do
The socket hets created when you start the server
It might be in the mysql home dir, it might be in /var/run.
See if its declared in my.cnf
Sent via BlackBerry from T-Mobile
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi
thanks for your reply.
i found the problem, the problem was due to maintenance activity IT team
rebooted the machine but they didn't start the mysql server after reboot.
i executed mysqld with root credit. i got the below output but still the
cursor not return to prompt
bash-2.03#
-socket-path=/home/qsys/mysql-5.1.32/tmp/mysql.sock
make
make install
mkdir /home/qsys/mysql-5.1.32/var
/home/qsys/mysql-5.1.32/bin/mysql_upgradeat this point I get mysqlcheck: Got
error 202: Can't connect to local MySQL server through socket
'/home/qsys/mysql-5.1.32/temp/mysql.sock'I have tried:1
--prefix=/home/qsys/mysql-5.1.32 \
--with-unix-socket-path=/home/qsys/mysql-5.1.32/tmp/mysql.sock
make
make install
mkdir /home/qsys/mysql-5.1.32/var
/home/qsys/mysql-5.1.32/bin/mysql_upgrade
at this point I get mysqlcheck: Got error 202: Can't connect to local MySQL
server through socket
Greetings to all,
I am having a weird issue with MySQL that I can't solve. We are getting
intermittent client connection errors code 2003 to the database server for
10mins seemingly at random, and after 20+ days of uptime. Unfortunately, I
have not been able to correlate these connection
HI Pieter
I have a suggestion.this might not be very helpful
Try to reconfigure the connections between the client and Mysql
server where the problem exists.and then try to notice the
uptime and logs of the server.
CHAVA
On Mon, Aug 18, 2008 at 12:00 PM,
Regardless of who has implemented the network and the status of
provided monitoring tools, this has all the look and feel of
intermittent network issues. I would run an independant network scan
(maybe nmap?) from one of the affected clients to the affected host
and I bet you will find that the
Make sure your mysqld is running
On Fri, Apr 4, 2008 at 3:24 AM, Joerg Bruehe [EMAIL PROTECTED] wrote:
Hi,
Vidal Garza wrote:
[[...]]
I have a cuestion, where do you find the system header files error
number (61)?
I do that brute-force:
#! /bin/sh
#
# FGIN shell
`
fi
done
but it return error on the screen like and this its my PROBLEM! I would
like that all connections finish ok. The errors not apear on mysql_error
file.
: Can't connect to local MySQL server through socket '/tmp/mysql.sock'
(61)
ERROR 2002 (HY000): Can't connect to local MySQL
# mysql --version
mysql Ver 14.12 Distrib 5.0.51a, for portbld-freebsd6.3 (i386) using 5.2
[[...]]
but it return error on the screen like and this its my PROBLEM! I would
like that all connections finish ok. The errors not apear on mysql_error
file.
: Can't connect to local MySQL server
...
I change the connection metod script.
I set
#!/bin/sh
...
/usr/local/bin/mysql -h 127.0.0.1 -u root -pmypassword MYDB -e $query
...
the -h option but i have a another message error...
...
...
ERRORERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (60)
ERROR 2003 (HY000) 2003 (HY000
Hi,
Vidal Garza wrote:
[[...]]
I have a cuestion, where do you find the system header files error
number (61)?
I do that brute-force:
#! /bin/sh
#
# FGIN shell script to use fgrep on all
/usr/include/h files
#
# $1, $2, ... options and arguments given to fgrep
connect to local MySQL server through socket '/tmp/mysql.sock' (61)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (61)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (61)
ERROR 2002 (HY000): Can't connect to local
:48 PM
To: John Mancuso
Subject: RE: ERROR 2002 (HY000): Can't connect to local MySQL server
mysqld_safe
Starting mysqld daemon with databases from /var/lib/mysql STOPPING
server from pid file /var/run/mysqld/mysqld.pid
070619 17:40:10 mysqld ended
--- John Mancuso [EMAIL PROTECTED] wrote
.
However I could not connect to mysql again
When I start mysql I get the following error
$ mysql
ERROR 2002 (HY000): Can't connect to local MySQL
server through socket '/var/lib/mysql/mysql.sock'
(111)
I could not start nor stop any running mysql
I tried to reboot my system hoping that the process
c: 516-652-2475
-Original Message-
From: Ahamarshan jn [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 19, 2007 11:54 AM
To: mysql@lists.mysql.com
Subject: ERROR 2002 (HY000): Can't connect to local MySQL server
Hi,
I was appending Grant previledges to some databases in mysql; either i
: Ahamarshan jn [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 19, 2007 12:25 PM
To: John Mancuso
Subject: RE: ERROR 2002 (HY000): Can't connect to local MySQL server
Hiya,
I could not find .err file anywhere.
and my mysql.sock file is showing 0 bytes in it.
- ash#
--- John Mancuso [EMAIL PROTECTED
:48 PM
To: John Mancuso
Subject: RE: ERROR 2002 (HY000): Can't connect to local MySQL server
mysqld_safe
Starting mysqld daemon with databases from /var/lib/mysql STOPPING
server from pid file /var/run/mysqld/mysqld.pid
070619 17:40:10 mysqld ended
--- John Mancuso [EMAIL PROTECTED] wrote:
Hiya
Hi,
I have an interesting (a.k.a. frustrating) problem on MySQL 4.1.11.
I try to connect to the database via DBD::mysql. Everything works - except in a
few cases (once in every 1 occasions, approximately) I get:
DBI connect('database=test:host=192.168.0.200','test',...) failed: Can't
Hi Faygal,
Fagyal Csongor wrote:
for (1..5) {
$dbh = DBI-connect($dsn, $user, $password, {'RaiseError' = 1} );
my $sth = $dbh-prepare('SELECT * FROM users');
}
I think you are simply running out of available outgoing ports with
that. Here is some more insight on that topic:
Nils Meyer wrote:
Hi Faygal,
Fagyal Csongor wrote:
for (1..5) {
$dbh = DBI-connect($dsn, $user, $password, {'RaiseError' = 1} );
my $sth = $dbh-prepare('SELECT * FROM users');
}
I think you are simply running out of available outgoing ports with
that. Here is some more insight
/sbin/mysqld --basedir=/
--datadir=/var/lib/mysql --user=mysql
--pid-file=/var/lib/mysql/puma.wellesley.edu.pid --skip-locking
So, it looks like the server is running, but for some reason I can't
connect. I've tried a bunch of other ways (such as starting it with
--skip-grant-tables) but no luck
problem.
I apologize for the mistake.
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:root
Organization:
Wellesley College Computer Science
MySQL support: none
Synopsis: can't connect to server and can't reset root password
Severity
() [function.mysql-pconnect]: Can't connect to
local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in
/web_sites/web/db_fns.php on line 6.
So far as I can remember, the only places I made edits were in
/etc/php5/apache2/php.ini, and /etc/mysql/my.cnf.
In /etc/php5/apache2/php.ini
On 6/8/06, Frances [EMAIL PROTECTED] wrote:
Daniel da Veiga wrote:
On 6/8/06, Frances [EMAIL PROTECTED] wrote:
what's event viewer? (searched google for error 1067, so opened .err
file, this is what is says (at the bottom, long file):
060607 22:37:33 [Note] mysqld: Shutdown complete
=mysql_pconnect(localhost,root,);
The server returned the error 2002:
2002 Can't connect to local MySQL server through socket
'/var/mysql/lib/mysql.sock(13)'
The user running the php connection does not have permissions to open
/var/mysql/lib/mysql.sock.
I was suggested that the server may
. The operating system is Redhat
fedora core 4. The version of the mysql server is 4.1.3 Beta. I wanna connect
to the server using the following statement:
$db_connection=mysql_pconnect(localhost,root,);
The server returned the error 2002:
2002 Can't connect to local MySQL server through socket
:
2002 Can't connect to local MySQL server through socket
'/var/mysql/lib/mysql.sock(13)'
I was suggested that the server may not running, or the sockect is wrong. But
when I run the following statement, there was no error occured:
localhost#/usr/local/mysql/bin/mysql -uroot -S/var/mysql/lib
the error 2002:
2002 Can't connect to local MySQL server through socket
'/var/mysql/lib/mysql.sock(13)'
The user running the php connection does not have permissions to open
/var/mysql/lib/mysql.sock.
I was suggested that the server may not running, or the sockect is wrong. But
when I run
Community Edition - Standard (GPL)
- Aparently it's OK. But when I execute the command below occurs the
following error:
[EMAIL PROTECTED] mysql]# bin/mysqladmin version
bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2
On Tue, 28 Mar 2006, Áquila Chaves wrote:
To: mysql@lists.mysql.com
From: Áquila Chaves [EMAIL PROTECTED]
Subject: error: 'Can't connect to local MySQL server through socket
'/tmp/mysql.sock'
- When I execute the command mysqld_safe:
[EMAIL PROTECTED] mysql]# bin/mysqld_safe
hi,
since 3 days, i'm trying to connect to MYSQL 5.0.18 from php scripts using
Apache et Macromedia 2004 Dreamweaver.
Could someone help me doing this?
Best regard.
-
Nouveau : téléphonez moins cher avec Yahoo! Messenger ! Découvez les
persant mpote [EMAIL PROTECTED] wrote on 02/16/2006 10:29:37 AM:
hi,
since 3 days, i'm trying to connect to MYSQL 5.0.18 from php
scripts using Apache et Macromedia 2004 Dreamweaver.
Could someone help me doing this?
Best regard.
-
Nouveau :
, persant mpote wrote:
To: mysql@lists.mysql.com
From: persant mpote [EMAIL PROTECTED]
Subject: APACHE 2.0 can't connect to MYSQL 5 when using PHP 5.1.2
hi,
since 3 days, i'm trying to connect to MYSQL 5.0.18 from
php scripts using Apache et Macromedia 2004 Dreamweaver.
Could someone
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 mythconverg using
on the server
gandalf
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 via
Hi,
I'm trying to connect to the MySQL server on the RedHat AS 4 from a remote
Solaris SPARC box. When I run the command:
mysql -h HOSTNAME
I got the error as
ERROR 2003 (HY000): Can't connect to MySQL server on 'HOSTNAME' (145)
Could anyone please explain what the mean of the error message
Jenny Chen [EMAIL PROTECTED] wrote on 12/02/2005 12:27:33 PM:
Hi,
I'm trying to connect to the MySQL server on the RedHat AS 4 from a
remote
Solaris SPARC box. When I run the command:
mysql -h HOSTNAME
I got the error as
ERROR 2003 (HY000): Can't connect to MySQL server
12:27:33 PM:
Hi,
I'm trying to connect to the MySQL server on the RedHat AS 4 from a
remote
Solaris SPARC box. When I run the command:
mysql -h HOSTNAME
I got the error as
ERROR 2003 (HY000): Can't connect to MySQL server on 'HOSTNAME' (145)
Could anyone please explain
I got the error as
ERROR 2003 (HY000): Can't connect to MySQL server on 'HOSTNAME'
(145)
Could anyone please explain what the mean of the error message and
how
to
solve it?
Thanks,
Jenny
The value after the -h must
:27:33 PM:
Hi,
I'm trying to connect to the MySQL server on the RedHat AS 4
from a
remote
Solaris SPARC box. When I run the command:
mysql -h HOSTNAME
I got the error as
ERROR 2003 (HY000): Can't connect to MySQL server on 'HOSTNAME'
(145
I've just installed MySQL v5.0.15 on my 'Windows XP system and most ways
I want to connect to it fail. I don't see what I'm doing wrong. I've
searched the manual, the web, and the forums without seeing anything
that clearly addressed my problem. Help, please!
If I navigate through Programs /
Hello.
If I try to run mysqlshow, I see:
C:\Documents and Settings\Chrismysqlshow sql
mysqlshow: Access denied for user 'ODBC'@'localhost' (using
password: NO)
ODBC is default username that is used on Windows. Create a new user
account and use it to connect to the MySQL
hi,
mysql is a very goode software,so i made mysql_3.23_58 and mysql_4.1
in two of my server, and i changed the root password, but why i can't
connect to the mysql server from a client pc(use mysqlcc or any other
tools)?
the error message is:
[206] ERROR 1130: Host '218.4.**.***' is not allowed
zhou bin wrote:
hi,
mysql is a very goode software,so i made mysql_3.23_58 and mysql_4.1
in two of my server, and i changed the root password, but why i can't
connect to the mysql server from a client pc(use mysqlcc or any other
tools)?
the error message is:
[206] ERROR 1130: Host '218.4
MySQL 5.0.12, P2P Microsoft network
I cannot get the manual's instructions (24.1.9.6) to work for connecting from a
mysql client on a windows machine to a mysql server running on another windows
machine (xp and w2kpro repsectively)
The client machine can ping the server machine by name or IP
Gerald Williams [EMAIL PROTECTED] wrote on 09/20/2005 10:49:22 AM:
MySQL 5.0.12, P2P Microsoft network
I cannot get the manual's instructions (24.1.9.6) to work for
connecting from a mysql client on a windows machine to a mysql
server running on another windows machine (xp and w2kpro
[EMAIL PROTECTED] wrote:
Gerald Williams [EMAIL PROTECTED] wrote on 09/20/2005 10:49:22 AM:
MySQL 5.0.12, P2P Microsoft network
I cannot get the manual's instructions (24.1.9.6) to work for
connecting from a mysql client on a windows machine to a mysql
server running on another windows
Note that if you set the password by directly editing (UPDATE) the
mysql.user table like this, you will have to run
FLUSH PRIVILEGES;
Thank you. That solved the problem connecting from the mysql client.
It changed the problem connecting via the 'Test' button from the ODBC
Administrator, to
it sounds like you need to look at, and potentially cleanup (or make
your mysql access entries match) what's in the inverse-map record for
the IPnumbers of your machines.
when you connect mysql takes the IPnumber on the inbound connection,
looks it up in DNS and then checks the result against the
Description:
I get the following message error: 'Can't connect to local MySQL
server through socket '/tmp/mysql.sock' (61)' Everything has run
fine for along time. This is running on OS X server 10.3 and ever
since the ran the last software update mysql has not be available.
I have
Ed Collins wrote:
Description:
I get the following message error: 'Can't connect to local MySQL
server through socket '/tmp/mysql.sock' (61)'
This is the error the client gives when it cannot connect to the server,
usually because the server isn't running.
Everything has run
I can't connect to Mysql from a remote computer yet I can log in fine
locally. When I telnet from a remote computer to port 3306, I get a
response. The response wasn't meaningful but it was a response.
Any ideas?
Salama
--
MySQL General Mailing List
For list archives: http
On Tuesday 12 July 2005 14:25, Salama hussein typed:
I can't connect to Mysql from a remote computer yet I can log in fine
locally. When I telnet from a remote computer to port 3306, I get a
response. The response wasn't meaningful but it was a response.
Exact error message?
--
MySQL General
Probably one problems with permissions.
Salama hussein wrote:
I can't connect to Mysql from a remote computer yet I can log in fine
locally. When I telnet from a remote computer to port 3306, I get a
response. The response wasn't meaningful but it was a response.
Any ideas?
Salama
Hi All,
I had posted a query few days back that I couldn't connect to mysql database
from a network machine. So for that I added two entries in my firewall
exceptions.
I added the Port 3306 and mysqld, so firewall should allow any connection to
database from external computer. My problem
Hello.
Error 2013 means: Lost connection to MySQL server during query. See:
http://dev.mysql.com/doc/mysql/en/gone-away.html
rtroiana wrote:
Hi All,
I had posted a query few days back that I couldn't connect to mysql
database
from a network machine. So for that I
]
Sent: Monday, March 28, 2005 7:54 PM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: RE: 'Can't connect to local MySQL server' error
On Monday, March 28, 2005 21:36, bruce wrote:
hi...
a server went from RH8 to FC2. it appears that the guy who did the
upgrade didn't perfrom any
1 - 100 of 434 matches
Mail list logo
