Re: Can't Connect Localhost

2013-09-03 Thread hsv
2013/09/02 12:49 +0800, John Smith > > I looked in mysql.config.pl and no "localhost" :( > "mysql.config.pl" from what software damned? > "mysql.config.pl" does not exist in context of mysql It exists in the following folder on my Win8 box: /Program Files (x86)/MySQL/MySQL Server 5.5/bi

Re: Can't Connect Localhost

2013-09-03 Thread shawn green
Hello John, On 9/2/2013 12:49 AM, John Smith wrote: On Sun, 1/9/13, Reindl Harald 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 "

Re: Can't Connect Localhost

2013-09-01 Thread John Smith
On Sun, 1/9/13, Reindl Harald 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.

Re: Can't Connect Localhost

2013-09-01 Thread Howard Hart
uestion: How do I change from localhost to 124.0.0.1? > TIA > John > > ---- > On Sun, 1/9/13, Terry J Fundak wrote: > > Subject: Re: Can't Connect Localhost > To: mysql@lists.mysql.com > Cc: "John Smith" > Da

Re: Can't Connect Localhost

2013-09-01 Thread Reindl Harald
Am 01.09.2013 15:37, schrieb John Smith: > > On Sun, 1/9/13, Reindl Harald wrote: > > Subject: Re: Can't Connect Localhost > To: mysql@lists.mysql.com > Date: Sunday, 1 September, 2013, 1:34 PM > > where you can

Re: Can't Connect Localhost

2013-09-01 Thread John Smith
On Sun, 1/9/13, Reindl Harald 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 crystal balls we

Re: Can't Connect Localhost

2013-09-01 Thread Reindl Harald
where you can change this? typically in the config file of teh software without crystal balls we don't know what about tell us what software you are speaking about? please realize that you have a very bad style of asking questions http://www.catb.org/esr/faqs/smart-questions.html#before Am 01.09

Re: Can't Connect Localhost

2013-09-01 Thread 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? TIA John On Sun, 1/9/13, Terry J Fundak wrote: Subject: Re: Ca

Re: Can't Connect Localhost

2013-08-31 Thread Terry J Fundak
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 e

Re: Can't Connect Localhost

2013-08-31 Thread Reindl Harald
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

Re: Can't Connect Localhost

2013-08-31 Thread Reindl Harald
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

Re: Can't Connect Localhost

2013-08-31 Thread Reindl Harald
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

Re: Can't connect as non-root user to database

2012-03-16 Thread shawn green
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 wi

Re: Can't connect as non-root user to database

2012-03-16 Thread Claudio Nanni
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 and

Re: Can't connect as non-root user to database

2012-03-16 Thread Clemens Eisserer
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 o

Re: Can't connect as non-root user to database

2012-03-16 Thread Clemens Eisserer
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

Re: Can't connect as non-root user to database

2012-03-16 Thread shawn green
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 strang

Re: Can't connect as non-root user to database

2012-03-16 Thread Rik Wasmus
> > 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

Re: Can't connect as non-root user to database

2012-03-16 Thread Claudio Nanni
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 > you probably have the anonymous user account taking over: ''@'localhost' > > when you specify the host with -h you

Re: Can't connect as non-root user to database

2012-03-16 Thread Claudio Nanni
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 Claud

Re: Can't connect as non-root user to database

2012-03-16 Thread Clemens Eisserer
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: ERR

Re: Can't connect as non-root user to database

2012-03-16 Thread Claudio Nanni
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 'someone

Re: Can't connect as non-root user to database

2012-03-16 Thread Rik Wasmus
> 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 mys

Re: Can't connect as non-root user to database

2012-03-16 Thread Clemens Eisserer
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

Re: Can't connect to MySQL server on '127.0.0.1' (111)

2011-04-02 Thread xPol
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: http://lists.

Re: Can't connect to MySQL server on '127.0.0.1' (111)

2011-04-02 Thread Reindl Harald
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..

Re: Can't connect to MySQL server on '127.0.0.1' (111)

2011-04-02 Thread xPol
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 > > "net

Re: Can't connect to MySQL server on '127.0.0.1' (111)

2011-04-02 Thread Reindl Harald
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 --pr

Re: Can't connect to MySQL server on '127.0.0.1' (111)

2011-04-02 Thread xPol
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

Re: Can't connect to MySQL server on '127.0.0.1' (111)

2011-04-02 Thread xPol
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 -- defau

Re: Can't connect to MySQL server on '127.0.0.1' (111)

2011-04-02 Thread Andrew Moore
I think you'll need to give us a bit more to go on. I presume this is a web based app? What have you changed? Has the MySQL daemon stopped? What have you changed? On Sat, Apr 2, 2011 at 4:10 PM, xPol wrote: > I have been using my local dictionary for years, accessing from web > browser, > poin

Re: Can't connect to MySQL server on '127.0.0.1' (111)

2011-04-02 Thread Reindl Harald
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? Am 02.04.2011 17:10, schrieb xPol: > I have been using my local dictionary for years, accessing from web browser, > pointing to http://localhost:9000/ >

Re: can't connect to server using mysqladmin or mysql

2006-08-01 Thread scott . anderson
I would like to withdraw my earlier bug report with the same subject line. I discovered that an erroneous IP address for the server machine had gotten into /etc/hosts (due to some IP changes in my organization). Once the DNS error was resolved, I was able to connect correctly and fix the password

Re: can't connect to the MySQL server from remote machine?

2005-12-02 Thread SGreen
That means that the MySQL server installed on the machine on which you issued the command is running AND that it can be connected to by the local loopback address (127.0.0.1). This still does not mean that you can connect to it from any other machine as your firewall may permit local (within th

Re: can't connect to the MySQL server from remote machine?

2005-12-02 Thread Jenny Chen
Hi, I tried with "telnet localhost 3306" locally, and got the message as: "Connected to localhost.localdomain (127.0.0.1). Escape character is '^]'. = 5.0.16-standard!QS//?.e,7~9>iw;]E!r=Connection closed by foreign host." What is this meaning? Thanks, Jenny On 12/2/05, Fernando Antunes <[EMAI

Re: can't connect to the MySQL server from remote machine?

2005-12-02 Thread Jenny Chen
Yes, I did try both hostname and IP, but can't work although I can ping to the two boxes from each other. Just wondering if it is because of the port(3306) got disabled?? Thanks, Jenny On 12/2/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > Jenny Chen <[EMAIL PROTECTED]> wrote on 12/

Re: can't connect to the MySQL server from remote machine?

2005-12-02 Thread SGreen
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

Re: Can't connect to MySQL v5.0.15 on 'Windows XP

2005-11-16 Thread Gleb Paharenko
Hello. > If I try to run mysqlshow, I see: > > C:\Documents and Settings\Chris>mysqlshow 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 se

Re: Can't connect to mysql server from another windows box

2005-09-20 Thread Gerald Williams
>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

Re: Can't connect to mysql server from another windows box

2005-09-20 Thread Gerald Williams
>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, t

Re: Can't connect to mysql server from another windows box

2005-09-20 Thread Michael Stassen
[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 ma

Re: Can't connect to mysql server from another windows box

2005-09-20 Thread SGreen
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 w2kpr

Re: Can't connect from remote computer

2005-07-12 Thread Nuno Pereira
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 --

Re: Can't connect from remote computer

2005-07-12 Thread Duncan Hill
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 Gener

Re: Can't connect to Local Mysql database server

2005-06-08 Thread Gleb Paharenko
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

RE: 'Can't connect to local MySQL server....' error

2005-03-29 Thread bruce
e- From: Tom Crimmins [mailto:[EMAIL PROTECTED] 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 RH

RE: 'Can't connect to local MySQL server....' error

2005-03-28 Thread Tom Crimmins
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 backups... > > i get a 'Can't connect to local MySQL server through socket...' error. > > i've tried to 'fix' the tables 'mysql_fix_privileg

Re: Can't connect

2004-11-02 Thread Jennifer Goodie
-- Original message -- From: none none <[EMAIL PROTECTED]> > Perhaps you did'nt grant access to for your home workstation IP > address to have permission to log into the mysql server? Check out the > grant command: > > http://dev.mysql.com/doc/mysql/en/GRANT.html I

Re: Can't connect

2004-11-02 Thread ian douglas
It doesn't say access denied so I assume the socket is not even open. Never assume :o) From your windows box, you could try: telnet host.domain.com 3306 ... if it connects, it connected to *something* How can I find out if MySQL is on the port 3306? What Linux command shows all active ports

Re: Can't connect to local MySQL server through socket'/var/lib/m ysql/mysql.sock'

2004-11-01 Thread ian douglas
[EMAIL PROTECTED] root]# ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock [mysqld] port= 3306 socket = /var/lib/mysql/mysql.sock Which is fine ... you neglected to say whether or not that fixed your problem? -id -- MySQL General Mailing List For list archives: http://lists.mys

Re: Can't connect to local MySQL server through socket'/var/lib/m ysql/mysql.sock'

2004-11-01 Thread Cecep Rosuludin
key_buffer = 16K max_allowed_packet = 1M table_cache = 4 sort_buffer_size = 64K net_buffer_length = 2K thread_stack = 64K server-id = 1 - Original Message - From: ian douglas <[EMAIL PROTECTED]> To: Cecep Rosuludin <[EMAIL PROTECTED]> Subject: Re: Can't connect to l

Re: Can't connect to local MySQL server through socket'/var/lib/m ysql/mysql.sock'

2004-11-01 Thread ian douglas
[EMAIL PROTECTED] root]# ls -l /var/lib/mysql total 20564 -rw-rw 1 mysql mysql25088 Nov 1 14:10 ib_arch_log_00 -rw-rw 1 mysql mysql 10485760 Nov 2 07:39 ibdata1 -rw-rw 1 mysql mysql 5242880 Nov 2 07:39 ib_logfile0 -rw-rw 1 mysql mysql 5242880 Nov 1 14:10 ib_log

Re: Can't connect to local MySQL server through socket'/var/lib/m ysql/mysql.sock'

2004-11-01 Thread Cecep Rosuludin
(delete) 2.MySQL-server-4.1.7-0.i386.rpm (I removed by rpm -e ) 3.the third one, I install mysql from Mandrake cd installer - Original Message - From: Spenser <[EMAIL PROTECTED]> To: Cecep Rosuludin <[EMAIL PROTECTED]> Subject: Re: Can't connect to local MySQL server thr

Re: Can't connect to local MySQL server through socket'/var/lib/m ysql/mysql.sock'

2004-11-01 Thread Cecep Rosuludin
Spenser, thanks for respons, I have done what you've ever done. this the result [EMAIL PROTECTED] root]# ps -e | grep mysql [EMAIL PROTECTED] root]# - Original Message - From: Spenser <[EMAIL PROTECTED]> To: Cecep Rosuludin <[EMAIL PROTECTED]> Subject: Re: Can't

Re: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

2004-11-01 Thread Pahlevanzadeh Mohsen
It can has many reason: 1.Your Socket file doesn't exist! 2.If it does exist,Please kill your mysql & instead of running its daemon,run its file in bg mode. (with & sign) --- Cecep Rosuludin <[EMAIL PROTECTED]> wrote: > Dear AlL, > > my former question is "how to run mysql service". > but now

Re: Can't connect to DB after upgrading to mysql 4.1.5

2004-10-05 Thread Paul DuBois
At 8:27 -0700 10/5/04, Claire Lee wrote: Hi, I have a perl script that connect to mysql using the following: my $dbh = DBI->connect("DBI:mysql:$dbname;host=$host","$dblogin", "$dbpasswd") or die "Cannot connect to $dbname: " . $DBI::errstr; But after I upgraded to 4.1.5 I get the following error me

Re: Can't connect to DB after upgrading to mysql 4.1.5

2004-10-05 Thread SGreen
If you are using an ODBC driver or some other pre-4.1 library to connect to a post-4.1 MySQL server you can get the message you describe. Here is some reading about cross-version authentication issues: http://dev.mysql.com/doc/mysql/en/Problems.html (esp section A.2) http://dev.mysql.com/doc/mysq

RE: Can't connect to DB after upgrading to mysql 4.1.5

2004-10-05 Thread Kevin Cowley
Claire The Authentication protocols changed with 4.1. If you do a search on the archive this subject has come up several times. Either upgrade your perl interface or make 4.1.5 use the old protocol. Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alche

RE: Can't connect to local MySQL server through socket

2004-08-18 Thread Victor Pendleton
Either the socket has been removed or is in a different location than you think. Try connecting by host and port. I would also verify with a database restart that the socket is being created where you think it is. If you continue to have issues look over this page to see if it helps. http://dev.mys

Re: Can't connect mysql.sock

2004-06-15 Thread Michael Stassen
Curtis Seyfried 2 wrote: Yes, Linux RH9 2.4.08 When I run the /opt/lampp/lampp start command, Apache starts, SSL, starts and another service, mysql seems to start. But when I try to connect to mysql with admin or cc or other tools, so I can setup databases and tables, it tells me mysql is not runni

Re: Can't connect mysql.sock

2004-06-14 Thread Curtis Seyfried 2
Yes, Linux RH9 2.4.08 When I run the /opt/lampp/lampp start command, Apache starts, SSL, starts and another service, mysql seems to start. But when I try to connect to mysql with admin or cc or other tools, so I can setup databases and tables, it tells me mysql is not running. Then I issue /opt/l

Re: Can't connect mysql.sock

2004-06-14 Thread Michael Stassen
Curtis Seyfried 2 wrote: I just installed mysql using Xampp, an installer for Apache, Mysql, PHP installation. Everything else works fine, but mysql will not start with the Apache It is not clear what you mean by "mysql will not start with the Apache startup." Apache and MySQL are separate server

Re: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

2004-06-11 Thread Egor Egorov
You better download the binary release from mysql.com and install it. It's statically linked so it should work fine on all Linuxes. Correctly installed MySQL binary release works fine and generally needs no tweaking to start and run. -- For technical support contracts, goto https://order.

Re: Can't connect (error 2003) to mysql 5.0 on other server

2004-04-04 Thread Mike Bosschaert
Bingo!! With the installation of the 5.0 (I assume) skip-networking was set by default in /etc/mysql/my.cnf. That was it. Thanks. Mike > I assume you have already verified that the mysql server is actually > running on server A. Have you verified that server A is accepting tcp > connections? Try

Re: Can't connect (error 2003) to mysql 5.0 on other server

2004-04-04 Thread Michael Stassen
I assume you have already verified that the mysql server is actually running on server A. Have you verified that server A is accepting tcp connections? Try running mysql -h mycompA -u mysql -p from server A. If it lets you in, try SELECT CURRENT_USER(); just to make sure it says @mycom

Re: Can't connect

2004-02-27 Thread Egor Egorov
"Andrea Beyreuther" <[EMAIL PROTECTED]> wrote: > I have the following problem: > > I can't connect to the mysql server. I always get error messages (access denied). > > I installed it on Windows XP Professional. > > The mysql server is running as service. A web server is running as service too (IIS

Re: Can't connect using C API

2004-02-18 Thread Cira Account
- Original Message - From: [EMAIL PROTECTED] Date: Wednesday, February 18, 2004 3:49 pm Subject: Re: Can't connect using C API > Do you fail with a user who has a password? > I don't know. I don't have any users with passwords. I did resolve my problem, thoug

Re: Can't connect using C API

2004-02-18 Thread vpendleton
Do you fail with a user who has a password? >> Original Message << On 2/17/04, 3:11:44 PM, Cira Account <[EMAIL PROTECTED]> wrote regarding Can't connect using C API: > I apologize if the listings below are badly > formatted. I am posting this from a webmail cl

Re: Can't connect using C API

2004-02-18 Thread Cira Account
I added "/tmp/mysql.sock" as the Unix socket and it worked. Thanks...Stephen - Original Message - From: Sasha Pachev <[EMAIL PROTECTED]> Date: Tuesday, February 17, 2004 7:12 pm Subject: Re: Can't connect using C API > > Error 261 on QNX means "connect

Re: Can't connect using C API

2004-02-17 Thread Sasha Pachev
Cira Account wrote: I apologize if the listings below are badly formatted. I am posting this from a webmail client and it has very short line lengths. I am using MySQL 4.0.17 on QNX 6.2.0. I can connect by typing "mysql -u root" from the command line. However, I get: Database connect failed

Re: Can't connect URGENT!

2004-02-08 Thread Tobias Asplund
On Sun, 8 Feb 2004 [EMAIL PROTECTED] wrote: > the only way I can connect to the server is typing > > mysql -h localhost -u root > make sure you don't have a line "skip-networking" in your /etc/my.cnf cheers, Tobias -- MySQL General Mailing List For list archives: http://lists.mysql.com/my

RE: Can't connect URGENT!

2004-02-07 Thread Peter Lovatt
PROTECTED]; [EMAIL PROTECTED] Subject: RE: Can't connect URGENT! Hmmm, I dunno. Perhaps the term: mysql -h 'server' -u root Should be changed to: mysql -h your_hostname -u root As "your_hostname" is the actual FQDN of your server. Brian Duke SS-TCAM//87797 -Original

RE: Can't connect URGENT!

2004-02-07 Thread Duke, Brian
Hmmm, I dunno. Perhaps the term: mysql -h 'server' -u root Should be changed to: mysql -h your_hostname -u root As "your_hostname" is the actual FQDN of your server. Brian Duke SS-TCAM//87797 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Saturday, February

Re: Can't connect URGENT!

2004-02-07 Thread Steve Folly
On 8 Feb 2004, at 00:29, [EMAIL PROTECTED] wrote: Hi, I have instaled mysql 4.0.17 on a debian server, but i have a big problem. I can only connect to mysql at the server and only with -h localhost. If I try this: mysql -h server -u root from anywhere i receice always the same response:

Re: Can't connect to MySQL server on 'localhost' (10061)

2004-01-29 Thread [EMAIL PROTECTED]
7;ll let you know if connecting from the laptop works. chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 28, 2004 6:40 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Can't connect to MySQL server on 'loc

Re: Can't connect to MySQL server on 'localhost' (10061)

2004-01-28 Thread [EMAIL PROTECTED]
I assume that you know the the server's ip and then try: from DOS: mysql -h ipaddressofserver -u user1 -ppassword1 --type this as is with your server's ip Also you need to be running 4.1.1 client on your laptop. N. Chris Frost wrote: With several others, I too have this problem. MySQL 4.1.1 ins

Re: Can't connect to MySQL server on 'localhost' (10061)

2004-01-28 Thread [EMAIL PROTECTED]
ednesday, January 28, 2004 4:15 PM To: N. Chris Frost Cc: [EMAIL PROTECTED] Subject: Re: Can't connect to MySQL server on 'localhost' (10061) I assume that you know the the server's ip and then try: from DOS: mysql -h ipaddressofserver -u user1 -ppassword1 --type this as is with

Re: Can't connect to MySQL server on 'localhost' (10061)

2004-01-28 Thread Brian Harris
I assume that you know the the server's ip and then try: from DOS: mysql -h ipaddressofserver -u user1 -ppassword1 --type this as is with your server's ip Also you need to be running 4.1.1 client on your laptop. N. Chris Frost wrote: With several others, I too have this problem. MySQL 4.1.1 ins

RE: Can't connect from localhost using 4.1.1 alpha

2004-01-28 Thread Russell Horn
> Also, if I (mysql -u root -p root) from localhost, then it prompts me > for a password. I enter password 'root' and then I get this error: That's what's supposed to happen: You use ~> mysql -u username -p database_name Then you are prompted for the password for root and it will start in data

Re: Can't connect to MySQL server

2004-01-10 Thread Aaron Gerber
Roger and Johannes, The default did have the "skip-networking" on. I commented that out as you advised, and it worked like a Charm!! I'm pretty excited to be able to have that working now. I really really appreciate the prompt reply and the consideration that you both took in your replies.

Re: Can't connect to MySQL server

2004-01-10 Thread Roger Baklund
* Aaron Gerber > I'm new to the list, hope this is the correct mailing list. It is. :) > I have a new installation of MySQL 4.0.16. Default binary installation > (apt-get). It's running on linux (morphix .4). > > Locally, I can connect to the MySQL server > > mysql -h localhost -p You are not

Re: Can't connect to MySQL server

2004-01-10 Thread Johannes Franken
* Aaron Gerber <[EMAIL PROTECTED]> [2004-01-10 21:33 +0100]: > Locally, I can connect to the MySQL server [...] > but I can't connect if I put in the IP address (locally or remotely) Maybe mysqld is configured to listen on its unix domain socket only? This is the default for Debian. Remove the li

Re: Can't connect to MySQL server on '[server]' (10061) - unix & tcp/ip sockets

2003-10-28 Thread Victoria Reznichenko
"Ben Darlow" <[EMAIL PROTECTED]> wrote: > > I've recently set up a new linux box and installed MySQL 4 (for the > record, Knoppix/Debian and the 'unstable' MySQL 4 package). I've had no > problems connecting using phpMyAdmin, but when I try to connect remotely > using MySQL Control Center or SQLyo

Re: Can't connect to MySQL from remote

2003-10-01 Thread Egor Egorov
[EMAIL PROTECTED] wrote: > I have some problems with MySQL 3.23.52 on RedHat Linux 8.0. > > I can connect to mysql when I am on the same machine but I can't connect to it from > another machine. Here is the error I get: > >> mysqladmin -u cedric -h gdvi02 version > mysqladmin: connect to server

[Fwd: Re: Can't connect to local MySQL question]

2003-08-14 Thread Andreas
--- Begin Message --- On 8/9/03 11:20 PM, "Andreas" <[EMAIL PROTECTED]> wrote: Andreas, Thanks for the help... The error log shows: 030810 14:52:48 mysqld started 030810 14:52:49 InnoDB: Started 030810 14:52:49 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 0308

Re: Can't connect to local MySQL question

2003-08-14 Thread Andreas
I forwarded your mail to the mysql list so that everyone who cares knows what is going. Bill Hernandez wrote: The error log shows: 030810 14:52:48 mysqld started 030810 14:52:49 InnoDB: Started 030810 14:52:49 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 030810 1

Re: Can't connect to local MySQL question

2003-08-10 Thread Eternal Designs, Inc
Andreas wrote: Bill Hernandez wrote: I followed the install instructions at http://entropy.ch , and was able to get mySql & php installed on my G4 -> (OSX 10.2.6) last night. I downloaded Navicat and setup a password for the mysql user. I created a connection called myDatabase_connection to a

Re: Can't connect to local MySQL question

2003-08-09 Thread Andreas
Bill Hernandez wrote: I followed the install instructions at http://entropy.ch , and was able to get mySql & php installed on my G4 -> (OSX 10.2.6) last night. I downloaded Navicat and setup a password for the mysql user. I created a connection called myDatabase_connection to a database called myD

Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock'

2003-03-06 Thread Prabu Subroto
What does, "rcmysql status" say? --- Mark <[EMAIL PROTECTED]> wrote: > Hi, I just installed 3.23.55 and I started getting > this message when > I run mysql from the shell. > > /tmp/mysql.sock exists and the permissions are right > and mysqld is > running, also the weird thing is that php is > conn

re: Can't connect to MySQL server & Access denied for root

2003-01-14 Thread Egor Egorov
On Monday 13 January 2003 14:21, Adrian Bucur wrote: > I removed an old mysql version and I installed a new one on a machine > running Suse 8.1 Linux. > shell>rpm -i MySQL-client-3.23.54a-1.i386.rpm > shell>rpm -i MySQL-shared-3.23.54a-1.i386.rpm > shell>rpm -i MySQL-devel-3.23.54a-1.i386.rpm > sh

RE: Can't connect to MySQL server & Access denied for root

2003-01-13 Thread Loren McDonald
Sounds like the same problem I'm having (for which I'm still stumped and don't know what has caused it): table mysql.user is read only. Test this by logging into mysql and using the GRANT or REVOKE statements. -- Loren McDonald Gods Of Music Reviewer/Editor [EMAIL PROTECTED] http://www.GodsOfM

RE: Can't connect error 10061 - nothing but Mascon works remotely - SOLVED (sorta)

2002-12-10 Thread Daevid Vincent
002 1:38 PM > To: Daevid Vincent; [EMAIL PROTECTED] > Subject: Re: Can't connect error 10061 - nothing but Mascon > works remotely. > > > Dear Daevid, > > > I don't have mySQL installed on the XP box, so I can't run > mysqladmin. > > I knew your a

Re: Can't connect error 10061 - nothing but Mascon works remotely.

2002-12-09 Thread Stefan Hinz, iConnect \(Berlin\)
--- Original Message - From: "Daevid Vincent" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "'Listen Hinz'" <[EMAIL PROTECTED]> Sent: Monday, December 09, 2002 9:09 PM Subject: RE: Can't connect error 10061 - nothing but Mascon wo

RE: Can't connect error 10061 - nothing but Mascon works remotely.

2002-12-09 Thread Daevid Vincent
> > [root@daevid]# mysqladmin ping -h daevid.com -uroot -p > [root@daevid]# > > mysqladmin ping -h 192.168.1.254 -uroot -p mysqld is alive > > But as I see, you tried the ping from the local host (i.e. > you connected from the same machine where the MySQL server is > running). What happens if

Re: Can't connect error 10061 - nothing but Mascon works remotely.

2002-12-09 Thread Listen Hinz
t (Berlin)'" <[EMAIL PROTECTED]> Sent: Monday, December 09, 2002 12:18 AM Subject: RE: Can't connect error 10061 - nothing but Mascon works remotely. [root@daevid]# mysqladmin ping -h daevid.com -uroot -p Enter password: mysqld is alive [root@daevid]# mysqladmin ping -h 19

RE: Can't connect error 10061 - nothing but Mascon works remotely.

2002-12-08 Thread Daevid Vincent
e "mysql-server-3.23.52-3" is really there though b/c I can't "rpm -e" it. [root@daevid root]# uname -r 2.4.18-14 > -Original Message- > From: Michael She [mailto:[EMAIL PROTECTED]] > Sent: Sunday, December 08, 2002 8:26 PM > To: Daevid Vincent >

RE: Can't connect error 10061 - nothing but Mascon works remotely.

2002-12-08 Thread Michael She
Sorry for jumping in late, but are you saying that you can't connect from a remote machine? Did you add a Host '%' to your username in the users table? At 07:36 PM 12/8/2002 -0800, Daevid Vincent wrote: *I* am the admin. I don't have a command line utility on my WinXP box. The command line uti

RE: Can't connect error 10061 - nothing but Mascon works remotely.

2002-12-08 Thread Daevid Vincent
08, 2002 7:05 PM > To: Daevid Vincent > Subject: Re: Can't connect error 10061 - nothing but Mascon > works remotely. > > > Greetings... > > Check out with your MySQL server administration. Are you able > to connect through the MySQL command line utility. >

RE: Can't connect error 10061 - nothing but Mascon works remotely.

2002-12-08 Thread Daevid Vincent
> Sent: Sunday, December 08, 2002 1:53 PM > To: Daevid Vincent; [EMAIL PROTECTED] > Cc: 'Karam Chand' > Subject: Re: Can't connect error 10061 - nothing but Mascon > works remotely. > > > Can't connect to MySQL server on 'daevid.com'(10061) >

Re: Can't connect error 10061 - nothing but Mascon works remotely.

2002-12-08 Thread Stefan Hinz, iConnect \(Berlin\)
t GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: "Daevid Vincent" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "'Karam Chand'" <[EMAIL PR

  1   2   >