Why ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.27.72' (111)?
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) # mysql select host, user, password from user; +-+--+---+ | host| user | password | +-+--+---+ | localhost | root | 023c30696e164488 | | vps192168027072 | root | | | 127.0.0.1 | root | | | localhost | | | | vps192168027072 | | | | localhost | monty| 0fc756bc026507b2 | | % | monty| 0fc756bc026507b2 | | localhost | gdnscenter | 184a22a73852ad5b | | % | gdns_replication | 2dbc2f8719c4ffcd | | % | root | 023c30696e164488 | | 192.168.23.73 | root | *EAB821151A3DE1A8FA76CD28D8F3BBD2389751F6 | | 0.0.0.0 | root | *EAB821151A3DE1A8FA76CD28D8F3BBD2389751F6 | +-+--+---+ 12 rows in set (0.00 sec) # And in 192.168.27.72 # service iptables status Firewall is stopped. # and there are not bind-address and skip_networking in my.cnf 。 I have installed the mysql in this way: # yum -y install mysql-server #vim /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 default-character-set = utf8 [mysql] default-character-set = utf8 [root@sample ~]# chkconfig mysqld on [root@sample ~]# chkconfig --list mysqld mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off chattr -i /etc/group chattr -i /etc/passwd chattr -i /etc/shadow chattr -i /etc/gshadow useradd mysql chattr +i /etc/group chattr +i /etc/passwd chattr +i /etc/shadow chattr +i /etc/gshadow chown mysql /var/run/mysqld/ cd /var/lib/mysql chown mysql -R * cd �C mysql_install_db --user=mysql --ldata=/var/lib/mysql [root@sample ~]# /etc/rc.d/init.d/mysqld start # Thank you
Re: Why ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.27.72' (111)?
Assuming Linux, check where it's listening using netstat -lptn. lx lxlenovos...@gmail.com 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 message is: ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.27.72' (111) # mysql select host, user, password from user; +-+--+---+ | host| user | password | +-+--+---+ | localhost | root | 023c30696e164488 | | vps192168027072 | root | | | 127.0.0.1 | root | | | localhost | | | | vps192168027072 | | | | localhost | monty| 0fc756bc026507b2 | | % | monty| 0fc756bc026507b2 | | localhost | gdnscenter | 184a22a73852ad5b | | % | gdns_replication | 2dbc2f8719c4ffcd | | % | root | 023c30696e164488 | | 192.168.23.73 | root | *EAB821151A3DE1A8FA76CD28D8F3BBD2389751F6 | | 0.0.0.0 | root | *EAB821151A3DE1A8FA76CD28D8F3BBD2389751F6 | +-+--+---+ 12 rows in set (0.00 sec) # And in 192.168.27.72 # service iptables status Firewall is stopped. # and there are not bind-address and skip_networking in my.cnf 。 I have installed the mysql in this way: # yum -y install mysql-server #vim /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 default-character-set = utf8 [mysql] default-character-set = utf8 [root@sample ~]# chkconfig mysqld on [root@sample ~]# chkconfig --list mysqld mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off chattr -i /etc/group chattr -i /etc/passwd chattr -i /etc/shadow chattr -i /etc/gshadow useradd mysql chattr +i /etc/group chattr +i /etc/passwd chattr +i /etc/shadow chattr +i /etc/gshadow chown mysql /var/run/mysqld/ cd /var/lib/mysql chown mysql -R * cd – mysql_install_db --user=mysql --ldata=/var/lib/mysql [root@sample ~]# /etc/rc.d/init.d/mysqld start # Thank you -- Sent from Kaiten Mail. Please excuse my brevity.
Re: Connect to MySQL server from a c++ application
On 06/08/2012 01:55 AM, Claudio Nanni wrote: Hi, you guys don't like the official API? http://dev.mysql.com/downloads/connector/c/ That's C isn't it? I think there is also a C++ connector. I'm interested to hear how that performs. It seems like a waste of time to write a bunch of wrappers for the C connector. -- simonsmicrophone.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Connect to MySQL server from a c++ application
Simon, yes it is C, C++ here: http://dev.mysql.com/downloads/connector/cpp/ I did not work with this libraries and to be honest I do not know about their performances, If you have the chance it would be extremely useful for the community having some tests done with both APIs. Cheers Claudio 2012/6/8 Simon Walter si...@gikaku.com On 06/08/2012 01:55 AM, Claudio Nanni wrote: Hi, you guys don't like the official API? http://dev.mysql.com/**downloads/connector/c/http://dev.mysql.com/downloads/connector/c/ That's C isn't it? I think there is also a C++ connector. I'm interested to hear how that performs. It seems like a waste of time to write a bunch of wrappers for the C connector. -- simonsmicrophone.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- Claudio
Re: Connect to MySQL server from a c++ application
On 06/07/2012 12:29 PM, Lars Nilsson wrote: On Wed, Jun 6, 2012 at 10:41 PM, Simon Waltersi...@gikaku.com wrote: However, memory leaks are not acceptable. So I am open to suggestions. What do other c++ programmers use? I've been happy using SQLAPI++ (http://www.sqlapi.com/) where I work. Commercial and not open source, but it's cross-platform and supports a dozen or so different databases. It looks nice. I'm looking for something open source. I'm fine using one of the SQL connectors. I just need to know which one works. How does SQLAPI++ connect to MySQL? Is it thread safe? -- simonsmicrophone.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Connect to MySQL server from a c++ application
On Thu, Jun 7, 2012 at 3:08 AM, Simon Walter si...@gikaku.com wrote: On 06/07/2012 12:29 PM, Lars Nilsson wrote: I've been happy using SQLAPI++ (http://www.sqlapi.com/) where I work. Commercial and not open source, but it's cross-platform and supports a dozen or so different databases. It looks nice. I'm looking for something open source. I'm fine using one of the SQL connectors. I just need to know which one works. How does SQLAPI++ connect to MySQL? Is it thread safe? It loads the libmysqlclient dll/so libraries under the hood, mapping each database client library's particular function set to its own internal function pointers. I believe it to be thread-safe (pthread mutexes on Linux/Unix, Windows relies on mutex/critical section objects). Instances of SAConnection objects should probably not be used across threads simultaneously though (usual caveats when doing multi-threaded programming apply, etc). I do like the high-level abstraction of the databases, and the use of exceptions for errors so every statement doesn't need to have a check to see if it was successful (just wrap your sequence of operations in a try/catch as makes sense for the application). I know it reduced my database-specific lines of code quite a bit when I changed a MySQL specific program to using SQLAPI++. If one need to, it is always possible to get a native database handle out that can be used with the database-specific API (at which point your program would have to be linked with the required database-specific client libraries, and so on), but it is not something I have really needed personally. If at all possible, I stay in the realm of SQLAPI++ which makes my program independent of the database libraries (implies I do not use native handles). It means I can compile my program without having Oracle installed for instance, and as long as a user has some means of configuring my program so that SA_Oracle_Client is passed to a connection object (mapping from string to the enum value or whatever else make sense), it should just work, given a proper connection string (as long as one handles the special cases properly as outlined in database specific notes for the classes and methods, etc) I'm sorry if I sound like a sales person for SQLAPI++. I have no relation to it, just a satisfied user. Lars Nilsson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Connect to MySQL server from a c++ application
Hi, you guys don't like the official API? http://dev.mysql.com/downloads/connector/c/ Cheers Claudio 2012/6/7 Lars Nilsson chamael...@gmail.com On Thu, Jun 7, 2012 at 3:08 AM, Simon Walter si...@gikaku.com wrote: On 06/07/2012 12:29 PM, Lars Nilsson wrote: I've been happy using SQLAPI++ (http://www.sqlapi.com/) where I work. Commercial and not open source, but it's cross-platform and supports a dozen or so different databases. It looks nice. I'm looking for something open source. I'm fine using one of the SQL connectors. I just need to know which one works. How does SQLAPI++ connect to MySQL? Is it thread safe? It loads the libmysqlclient dll/so libraries under the hood, mapping each database client library's particular function set to its own internal function pointers. I believe it to be thread-safe (pthread mutexes on Linux/Unix, Windows relies on mutex/critical section objects). Instances of SAConnection objects should probably not be used across threads simultaneously though (usual caveats when doing multi-threaded programming apply, etc). I do like the high-level abstraction of the databases, and the use of exceptions for errors so every statement doesn't need to have a check to see if it was successful (just wrap your sequence of operations in a try/catch as makes sense for the application). I know it reduced my database-specific lines of code quite a bit when I changed a MySQL specific program to using SQLAPI++. If one need to, it is always possible to get a native database handle out that can be used with the database-specific API (at which point your program would have to be linked with the required database-specific client libraries, and so on), but it is not something I have really needed personally. If at all possible, I stay in the realm of SQLAPI++ which makes my program independent of the database libraries (implies I do not use native handles). It means I can compile my program without having Oracle installed for instance, and as long as a user has some means of configuring my program so that SA_Oracle_Client is passed to a connection object (mapping from string to the enum value or whatever else make sense), it should just work, given a proper connection string (as long as one handles the special cases properly as outlined in database specific notes for the classes and methods, etc) I'm sorry if I sound like a sales person for SQLAPI++. I have no relation to it, just a satisfied user. Lars Nilsson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- Claudio
Re: Connect to MySQL server from a c++ application
There is also libdrizzle. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Connect to MySQL server from a c++ application
On Thu, Jun 7, 2012 at 12:55 PM, Claudio Nanni claudio.na...@gmail.com wrote: Hi, you guys don't like the official API? http://dev.mysql.com/downloads/connector/c/ Cheers Claudio Personally? Not really. For instance, memory leaks are not acceptable according to Simon's expressed desire. SQLAPI++ allows me to completely avoid explicit memory/resource allocation, if I put things on the stack. class Foo { int x; std::string y; } typedef std::mapint, Foo FooV; FooV vFoo; try { SAConnection db(db, user, password); SACommand cmd(db); cmd.setCommandText(SELECT id, name FROM foo); cmd.Execute(); while (cmd.FetchNext()) { Foo foo; foo.x = cmd.Field(1).asLong(); foo.y = (const char *)cmd.Field(2).asString(); vFoo[foo.x] = foo; } } catch (SAException e) { std::cerr Failure: (const char *)e.ErrText(); } Using MySQL's API I'd need to make sure I close connections I open, free result sets I get back, etc. SQLAPI++ perform these operations behind the scenes for me when objects are created/initialized and destroyed. If I happen to use pointers for some of these instead of putting them on the stack, the ball is back in my court again to make sure I don't lose track of something. This is my personal preference. YMMV. Lars Nilsson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Connect to MySQL server from a c++ application
What is the most stable and performant way to connect to a MySQL server from a c++ application? I've been using libmyodbc via unixODBC running under Debian squeeze. Suffice it to say, I am sorely disappointed. First of all the libmyodbc driver that's included with Debian is quite old. However, even after building and utilizing the latest version, there are still memory leaks in the driver. I'm not stuck on using ODBC. Though it's nice to be able to is use an ODBC library so that I can connect to various DBs without having to learn new APIs. There is also the benefit of being able to change databases without much effort. However, memory leaks are not acceptable. So I am open to suggestions. What do other c++ programmers use? (note: I know this is probably not the place to ask this, but the libmyodbc mailing is dead as a door nail with people's auto-responders going off like a digital ghost town. :/) Thanks, Simon -- simonsmicrophone.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Connect to MySQL server from a c++ application
On Wed, Jun 6, 2012 at 10:41 PM, Simon Walter si...@gikaku.com wrote: However, memory leaks are not acceptable. So I am open to suggestions. What do other c++ programmers use? I've been happy using SQLAPI++ (http://www.sqlapi.com/) where I work. Commercial and not open source, but it's cross-platform and supports a dozen or so different databases. One of the example programs (without comments and the wrapping try/catch block) con.Connect(test, tester, tester, SA_Oracle_Client); cmd.setConnection(con); cmd.setCommandText( Insert into test_tbl(fid, fvarchar20) values(:1, :2)); cmd.Param(1).setAsLong() = 2; cmd.Param(2).setAsString() = Some string (2); cmd.Execute(); cmd (long)3 Some string (3); cmd.Execute(); con.Commit(); Simply replace SA_Oracle_Client with SA_MySQL_Client, etc, and you'll be working against MySQL. Only requirement is that the dll/so libraries for each database you want to connect to are installed properly. Lars Nilsson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Can't connect to MySQL server on '127.0.0.1' (111)
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? I am using linux/opensuse 11.4 Thank you p -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Can't connect to MySQL server on '127.0.0.1' (111)
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/ 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
Re: Can't connect to MySQL server on '127.0.0.1' (111)
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 xtek...@gmail.com wrote: 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? I am using linux/opensuse 11.4 Thank you p -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=eroomy...@gmail.com
Re: Can't connect to MySQL server on '127.0.0.1' (111)
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 -- defaults-file=/home/xpol/.local/share/akonadi//mysql.conf -- datadir=/home/xpol/.local/share/akonadi/db_data/ -- socket=/home/xpol/.local/share/akonadi/socket-ambi.site/mysql.socket So the demon appears to be running I do not think mysql conf files have been changed by me thank you --p -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Can't connect to MySQL server on '127.0.0.1' (111)
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 ~ (17:32-Sat 2) (Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.) Active Internet connections (w/o servers) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp0 0 10.121.243.241:3831574.125.77.109:smtp TIME_WAIT - tcp0 0 127.0.0.1:50793 127.0.0.1:48856 ESTABLISHED 6752/npviewer.bin tcp0 0 127.0.0.1:57336 127.0.0.1:48856 ESTABLISHED 6752/npviewer.bin tcp0 0 10.121.243.241:5392474.125.232.152:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:5392574.125.232.152:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:5389474.125.232.152:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:35673209.85.227.189:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:35672209.85.227.189:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:48554209.85.149.105:www-http ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:35666209.85.227.189:https TIME_WAIT - tcp0 0 10.121.243.241:35667209.85.227.189:https TIME_WAIT - tcp0 0 10.121.243.241:5392674.125.232.152:https ESTABLISHED 6252/firefox tcp0 0 127.0.0.1:52722 127.0.0.1:48856 ESTABLISHED 6752/npviewer.bin tcp0 0 127.0.0.1:48856 127.0.0.1:52722 ESTABLISHED 6767/GoogleTalkPlug tcp0 0 127.0.0.1:48856 127.0.0.1:50793 ESTABLISHED 6767/GoogleTalkPlug tcp0 0 127.0.0.1:48856 127.0.0.1:57336 ESTABLISHED 6767/GoogleTalkPlug tcp0 0 10.121.243.241:5432480.91.229.10:nntp ESTABLISHED 11402/knodeo10783.s --- (xpol) % cat /mnt/etc/my.cnf | grep -v ^# ~ (17:34-Sat 2) [client] port= 3306 socket = /var/run/mysql/mysql.sock [mysqld] port= 3306 socket = /var/run/mysql/mysql.sock datadir = /var/lib/mysql skip-locking key_buffer_size = 16M max_allowed_packet = 1M table_open_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M log-bin=mysql-bin binlog_format=mixed server-id = 1 [safe_mysqld] log-error = /var/log/mysql/mysqld.log socket = /var/run/mysql/mysql.sock !include_dir /etc/mysql [mysqldump] socket = /var/run/mysql/mysql.sock quick max_allowed_packet = 16M [mysql] no-auto-rehash [myisamchk] key_buffer_size = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout [mysqld_multi] mysqld = /usr/bin/mysqld_safe mysqladmin = /usr/bin/mysqladmin log= /var/log/mysqld_multi.log - -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Can't connect to MySQL server on '127.0.0.1' (111)
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 --programs -u -t -l as ROOT on the machine where mysql is running! alterante: telnet 127.0.0.1 3306 /mnt/etc/my.cnf is really your active mysql-config? normally /etc/my.cnf is used, even if /etc/ is a own disk/partition you should never mount it as /mnt/etc/ and managing with symlinks - mount it directly to /etc i would assume something like skip-networking in your config if connection fails anyways this mysql-config ma contain some includes because the line !include_dir /etc/mysql Am 02.04.2011 17:36, schrieb 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 ~ (17:32-Sat 2) (Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.) Active Internet connections (w/o servers) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp0 0 10.121.243.241:3831574.125.77.109:smtp TIME_WAIT - tcp0 0 127.0.0.1:50793 127.0.0.1:48856 ESTABLISHED 6752/npviewer.bin tcp0 0 127.0.0.1:57336 127.0.0.1:48856 ESTABLISHED 6752/npviewer.bin tcp0 0 10.121.243.241:5392474.125.232.152:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:5392574.125.232.152:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:5389474.125.232.152:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:35673209.85.227.189:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:35672209.85.227.189:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:48554209.85.149.105:www-http ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:35666209.85.227.189:https TIME_WAIT - tcp0 0 10.121.243.241:35667209.85.227.189:https TIME_WAIT - tcp0 0 10.121.243.241:5392674.125.232.152:https ESTABLISHED 6252/firefox tcp0 0 127.0.0.1:52722 127.0.0.1:48856 ESTABLISHED 6752/npviewer.bin tcp0 0 127.0.0.1:48856 127.0.0.1:52722 ESTABLISHED 6767/GoogleTalkPlug tcp0 0 127.0.0.1:48856 127.0.0.1:50793 ESTABLISHED 6767/GoogleTalkPlug tcp0 0 127.0.0.1:48856 127.0.0.1:57336 ESTABLISHED 6767/GoogleTalkPlug tcp0 0 10.121.243.241:5432480.91.229.10:nntp ESTABLISHED 11402/knodeo10783.s --- (xpol) % cat /mnt/etc/my.cnf | grep -v ^# ~ (17:34-Sat 2) [client] port= 3306 socket = /var/run/mysql/mysql.sock [mysqld] port= 3306 socket = /var/run/mysql/mysql.sock datadir = /var/lib/mysql skip-locking key_buffer_size = 16M max_allowed_packet = 1M table_open_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M log-bin=mysql-bin binlog_format=mixed server-id = 1 [safe_mysqld] log-error = /var/log/mysql/mysqld.log socket = /var/run/mysql/mysql.sock !include_dir /etc/mysql [mysqldump] socket = /var/run/mysql/mysql.sock quick max_allowed_packet = 16M [mysql] no-auto-rehash [myisamchk] key_buffer_size = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout [mysqld_multi] mysqld = /usr/bin/mysqld_safe mysqladmin = /usr/bin/mysqladmin log= /var/log/mysqld_multi.log - -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ signature.asc Description: OpenPGP digital signature
Re: Can't connect to MySQL server on '127.0.0.1' (111)
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 --numeric-hosts --notrim --programs -u -t -l as ROOT on the machine where mysql is running! alterante: telnet 127.0.0.1 3306 sorry, i have re-enterd the command as root - here incuded /mnt/etc/my.cnf is really your active mysql-config? normally /etc/my.cnf is used, even if /etc/ is a own disk/partition you should never mount it as /mnt/etc/ and managing with symlinks - mount it directly to /etc you're right, /mnt/etc/my.cnf is not my ususm cnf file I hd mounnted that file system to compare with /etc/my.cnf They are the same, however. Here included also /etc/mysqlaccess.conf i would assume something like skip-networking in your config if connection fails it is there, but commented out: /etc/my.cnf:#skip-networking anyways this mysql-config ma contain some includes because the line !include_dir /etc/mysql / That dir contains: /etc/mysql/default_plugins.cnf its contents is here included thank you p 1- % ° netstat --numeric-hosts --notrim --programs -u -t ~ (18:09-Sat 2) Active Internet connections (w/o servers) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp0 0 10.121.243.241:6057774.125.232.149:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:5420774.125.232.114:www-http ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:4954585.86.166.196:7168 TIME_WAIT - tcp0 0 10.121.243.241:5317374.125.232.150:https TIME_WAIT - tcp0 0 127.0.0.1:50793 127.0.0.1:48856 ESTABLISHED 6752/npviewer.bin tcp0 0 127.0.0.1:57336 127.0.0.1:48856 ESTABLISHED 6752/npviewer.bin tcp0 0 10.121.243.241:39556209.85.227.189:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:6057674.125.232.149:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:39551209.85.227.189:https TIME_WAIT - tcp0 0 10.121.243.241:4108983.233.30.55:ipsec-nat-t TIME_WAIT - tcp0 0 10.121.243.241:39550209.85.227.189:https TIME_WAIT - tcp0 0 10.121.243.241:5275883.51.48.124:44909 TIME_WAIT - tcp0 0 127.0.0.1:52722 127.0.0.1:48856 ESTABLISHED 6752/npviewer.bin tcp0 0 127.0.0.1:48856 127.0.0.1:52722 ESTABLISHED 6767/GoogleTalkPlug tcp0 0 10.121.243.241:39555209.85.227.189:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:3536582.56.169.37:19907 TIME_WAIT - tcp0 0 10.121.243.241:5728380.91.229.10:nntp ESTABLISHED 12106/knodec10783.s tcp0 0 10.121.243.241:4455274.125.232.150:https ESTABLISHED 6252/firefox tcp0 0 127.0.0.1:48856 127.0.0.1:50793 ESTABLISHED 6767/GoogleTalkPlug tcp0 0 127.0.0.1:48856 127.0.0.1:57336 ESTABLISHED 6767/GoogleTalkPlug 2 (xpol) % ° cat /etc/mysqlaccess.conf | grep -v ^# ~ (18:20-Sat 2) #$Param{'host'} = ''; $Param{'user'} = 'nobody'; $Param{'db'} = 'test'; $Param{'password'} = 'foobar'; $Param{'debug'}= 0; if ($CMD) { $Param{'superuser'} = 'root'; $Param{'rhost'} = 'localhost'; $Param{'spassword'} = ''; $Param{'brief'} = 1; } if ($CGI) { $Param{'superuser'} = 'root'; $Param{'rhost'} = 'localhost'; $Param{'spassword'} = ''; $Param{'table'} = 1; } 1; #to make require happy 3-- (xpol) % ° cat /etc/mysql/default_plugins.cnf ~ (18:20-Sat 2) [server] plugin-load=blackhole=ha_blackhole.so plugin-load=federated=ha_federated.so plugin-load=archive=ha_archive.so - -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Can't connect to MySQL server on '127.0.0.1' (111)
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... Connected to 127.0.0.1. Escape character is '^]'. 5.5.10-log�K]qC7,t'��a4~Agb949^QXmysql_native_password if there is no connection we should find out why debug simply the web-app user on a local terminal to get error messages with more details as failed [harry@srv-rhsoft:~]$ mysql -h 127.0.0.1 -u myuser -p Enter password: ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using password: NO) this example says more as failed bceause we see that connection is possible but authentication fails Am 02.04.2011 18:21, schrieb 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 netstat --numeric-hosts --notrim --programs -u -t -l as ROOT on the machine where mysql is running! alterante: telnet 127.0.0.1 3306 sorry, i have re-enterd the command as root - here incuded /mnt/etc/my.cnf is really your active mysql-config? normally /etc/my.cnf is used, even if /etc/ is a own disk/partition you should never mount it as /mnt/etc/ and managing with symlinks - mount it directly to /etc you're right, /mnt/etc/my.cnf is not my ususm cnf file I hd mounnted that file system to compare with /etc/my.cnf They are the same, however. Here included also /etc/mysqlaccess.conf i would assume something like skip-networking in your config if connection fails it is there, but commented out: /etc/my.cnf:#skip-networking anyways this mysql-config ma contain some includes because the line !include_dir /etc/mysql / That dir contains: /etc/mysql/default_plugins.cnf its contents is here included thank you p 1- % ° netstat --numeric-hosts --notrim --programs -u -t ~ (18:09-Sat 2) Active Internet connections (w/o servers) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp0 0 10.121.243.241:6057774.125.232.149:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:5420774.125.232.114:www-http ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:4954585.86.166.196:7168 TIME_WAIT - tcp0 0 10.121.243.241:5317374.125.232.150:https TIME_WAIT - tcp0 0 127.0.0.1:50793 127.0.0.1:48856 ESTABLISHED 6752/npviewer.bin tcp0 0 127.0.0.1:57336 127.0.0.1:48856 ESTABLISHED 6752/npviewer.bin tcp0 0 10.121.243.241:39556209.85.227.189:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:6057674.125.232.149:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:39551209.85.227.189:https TIME_WAIT - tcp0 0 10.121.243.241:4108983.233.30.55:ipsec-nat-t TIME_WAIT - tcp0 0 10.121.243.241:39550209.85.227.189:https TIME_WAIT - tcp0 0 10.121.243.241:5275883.51.48.124:44909 TIME_WAIT - tcp0 0 127.0.0.1:52722 127.0.0.1:48856 ESTABLISHED 6752/npviewer.bin tcp0 0 127.0.0.1:48856 127.0.0.1:52722 ESTABLISHED 6767/GoogleTalkPlug tcp0 0 10.121.243.241:39555209.85.227.189:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:3536582.56.169.37:19907 TIME_WAIT - tcp0 0 10.121.243.241:5728380.91.229.10:nntp ESTABLISHED 12106/knodec10783.s tcp0 0 10.121.243.241:4455274.125.232.150:https ESTABLISHED 6252/firefox tcp0 0 127.0.0.1:48856 127.0.0.1:50793 ESTABLISHED 6767/GoogleTalkPlug tcp0 0 127.0.0.1:48856 127.0.0.1:57336 ESTABLISHED 6767/GoogleTalkPlug 2 (xpol) % ° cat /etc/mysqlaccess.conf | grep -v ^# ~ (18:20-Sat 2) #$Param{'host'} = ''; $Param{'user'} = 'nobody'; $Param{'db'} = 'test'; $Param{'password'} = 'foobar'; $Param{'debug'}= 0; if ($CMD) { $Param{'superuser'} = 'root'; $Param{'rhost'} = 'localhost'; $Param{'spassword'} = ''; $Param{'brief'} = 1; } if ($CGI) { $Param{'superuser'} = 'root'; $Param{'rhost'} = 'localhost'; $Param{'spassword'} = '';
Re: Can't connect to MySQL server on '127.0.0.1' (111)
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.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Can not connect to MYSQL server on Windows Vista 64 bit
I have a vb.net app that was running fine on two XP computers using Mysql 5.0 server. I switched to a new Vista 64 bit computer, and now it gives me a message that it can not connect to any mysql hosts.In Navicat, when I try to setup the connection, it gives message 2003 - Can't connect to mysql server on Dell1440 (10060) I have added port 3306 to the windows firewall, and after it didn't work, totally turned off the firewall. Now if I bring up the app, and go into a one record at a time update form, the first record will appear, but it won't page to the next one without the failure on the connection. Any ideas as to what I need to do to make it work properly. Thanks, David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Intermittent Can't connect to MySQL server on 'host' (4) (2003) after 20+ days uptime
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 problems with any other queries, jobs, etc, so I was hoping someone here might be able to help me out. The problem is as follows. Seemingly at random, the master suddenly stops accepting connections, and the clients return connection error 2003, indicating the master did not respond in a timely manner. This goes on for about 10 minutes, at which point the master starts accepting connections again, without any human input. This happened at 4am on Sunday morning for example, so it healed itself before I could get myself out of bed and comprehend the situation, let alone connect somewhere and try and fix it. We are seeing this happen about 4 or 5 times a week for the last 2 weeks, and there seems to be no pattern as to the time or date. Sometimes it happens twice in one day, and then disappears for 4 days. There was no spike in activity as far as we can tell, and the CPU and network usage were stable at about 2% and 4% of capacity respectively. Also, we have slow query log turned on and set to 1sec, and there are no queries anywhere near the gaps in connection. We are running MySQL 5.0.44 on a single master on its on hardware, with a replication slave on a different machine. We have a write through memcached setup in front my MySQL, which handles the majority of the requests, so MySQL is seeing about 20 to 30 ops (select, inserts, updates) per second on average. All of this is running on Amazon EC2 instances, and have dedicated boxes (we are running the 64bit Large Instance, which is supposed to be a dedicated virtual box with 2 CPU, 2 cores apiece and 8G of ram, with 1.5/2G free.) We then have two other machines that run the front end web servers running PHP 5.1.6 and load balancers, which connect to the database when the cache doesnt have the required information. I did not post this to the PHP section since it seems like a more general issue with the server as opposed to the clients. After the second time it happened, we switched out our AWS hardware in hopes that it was a hardware fluke, but to no avail. The problem reared its uglyhead 3 days later. We doubt it is the internal Amazon network since the external monitoring of the box continues to work and spit out information, and no other box is showing similar connection symptoms. Also, all of our boxes are in the same Amazon Zone, which implies that they are in the same colo. This makes me think that a combination of our configuration and queries are causing the trouble. I checked the archives, but it seems that the people who encountered this error saw it during setup/configuration, and not randomly after 30 days of uptime. I doubt anyone has the answer, so I was hoping someone could help me understand the best way to debug this problem in order to find the reason for these random outages. Thanks in advance for any and all help! Pieter de Zwart
Re: Intermittent Can't connect to MySQL server on 'host' (4) (2003) after 20+ days uptime
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, Pieter de Zwart [EMAIL PROTECTED] wrote: 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 problems with any other queries, jobs, etc, so I was hoping someone here might be able to help me out. The problem is as follows. Seemingly at random, the master suddenly stops accepting connections, and the clients return connection error 2003, indicating the master did not respond in a timely manner. This goes on for about 10 minutes, at which point the master starts accepting connections again, without any human input. This happened at 4am on Sunday morning for example, so it healed itself before I could get myself out of bed and comprehend the situation, let alone connect somewhere and try and fix it. We are seeing this happen about 4 or 5 times a week for the last 2 weeks, and there seems to be no pattern as to the time or date. Sometimes it happens twice in one day, and then disappears for 4 days. There was no spike in activity as far as we can tell, and the CPU and network usage were stable at about 2% and 4% of capacity respectively. Also, we have slow query log turned on and set to 1sec, and there are no queries anywhere near the gaps in connection. We are running MySQL 5.0.44 on a single master on its on hardware, with a replication slave on a different machine. We have a write through memcached setup in front my MySQL, which handles the majority of the requests, so MySQL is seeing about 20 to 30 ops (select, inserts, updates) per second on average. All of this is running on Amazon EC2 instances, and have dedicated boxes (we are running the 64bit Large Instance, which is supposed to be a dedicated virtual box with 2 CPU, 2 cores apiece and 8G of ram, with 1.5/2G free.) We then have two other machines that run the front end web servers running PHP 5.1.6 and load balancers, which connect to the database when the cache doesnt have the required information. I did not post this to the PHP section since it seems like a more general issue with the server as opposed to the clients. After the second time it happened, we switched out our AWS hardware in hopes that it was a hardware fluke, but to no avail. The problem reared its uglyhead 3 days later. We doubt it is the internal Amazon network since the external monitoring of the box continues to work and spit out information, and no other box is showing similar connection symptoms. Also, all of our boxes are in the same Amazon Zone, which implies that they are in the same colo. This makes me think that a combination of our configuration and queries are causing the trouble. I checked the archives, but it seems that the people who encountered this error saw it during setup/configuration, and not randomly after 30 days of uptime. I doubt anyone has the answer, so I was hoping someone could help me understand the best way to debug this problem in order to find the reason for these random outages. Thanks in advance for any and all help! Pieter de Zwart -- Sreekanth CHAVA
Re: Intermittent Can't connect to MySQL server on 'host' (4) (2003) after 20+ days uptime
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 same fluctuations occur on other ports. On Mon, Aug 18, 2008 at 3:22 PM, Sreekanth CHAVA [EMAIL PROTECTED] wrote: 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, Pieter de Zwart [EMAIL PROTECTED] wrote: 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 problems with any other queries, jobs, etc, so I was hoping someone here might be able to help me out. The problem is as follows. Seemingly at random, the master suddenly stops accepting connections, and the clients return connection error 2003, indicating the master did not respond in a timely manner. This goes on for about 10 minutes, at which point the master starts accepting connections again, without any human input. This happened at 4am on Sunday morning for example, so it healed itself before I could get myself out of bed and comprehend the situation, let alone connect somewhere and try and fix it. We are seeing this happen about 4 or 5 times a week for the last 2 weeks, and there seems to be no pattern as to the time or date. Sometimes it happens twice in one day, and then disappears for 4 days. There was no spike in activity as far as we can tell, and the CPU and network usage were stable at about 2% and 4% of capacity respectively. Also, we have slow query log turned on and set to 1sec, and there are no queries anywhere near the gaps in connection. We are running MySQL 5.0.44 on a single master on its on hardware, with a replication slave on a different machine. We have a write through memcached setup in front my MySQL, which handles the majority of the requests, so MySQL is seeing about 20 to 30 ops (select, inserts, updates) per second on average. All of this is running on Amazon EC2 instances, and have dedicated boxes (we are running the 64bit Large Instance, which is supposed to be a dedicated virtual box with 2 CPU, 2 cores apiece and 8G of ram, with 1.5/2G free.) We then have two other machines that run the front end web servers running PHP 5.1.6 and load balancers, which connect to the database when the cache doesnt have the required information. I did not post this to the PHP section since it seems like a more general issue with the server as opposed to the clients. After the second time it happened, we switched out our AWS hardware in hopes that it was a hardware fluke, but to no avail. The problem reared its uglyhead 3 days later. We doubt it is the internal Amazon network since the external monitoring of the box continues to work and spit out information, and no other box is showing similar connection symptoms. Also, all of our boxes are in the same Amazon Zone, which implies that they are in the same colo. This makes me think that a combination of our configuration and queries are causing the trouble. I checked the archives, but it seems that the people who encountered this error saw it during setup/configuration, and not randomly after 30 days of uptime. I doubt anyone has the answer, so I was hoping someone could help me understand the best way to debug this problem in order to find the reason for these random outages. Thanks in advance for any and all help! Pieter de Zwart -- Sreekanth CHAVA -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
failure to connect to mysql-server at localhost
Hi all, i am installing a library automation software called koha which uses mysql-server. i initially installed version5.0 and later uninstalled it because the system was giving me some errors. i installed the lower version(mysql-server-4.1). when reinstalling koha i get the following: MYSQL ROOT USER PASSWORD To create the koha database, please enter your mysql server's root user password: Password: CREATING DATABASE Creating the MySQL database for Koha... ERROR CREATING DATABASE /usr/bin/mysqladmin: connect to server at 'localhost' failed Couldn't connect to the MySQL server for the reason given above. This is a serious problem, the database will not get installed. Press ENTER to continue: i continued with with installation to the end. As a result of the above problem everything seems to work (adding members, searching and importing records from the internet using z39.50) But it doesnt add bibliographic records to the database- whenever i try to add records i get a server error. will be grateful if somebody can sort me out. i am using ubutu 6.06 operating system. Thanks kenneth
MYSQL connection failed: Can not connect to MySQL server
Hi,I have a mail system on FreeBSD 6.2 + Exim 4.62 + MySQL 5.0. Exim was compiled with MySQL support, the MySQL database is external to the mail server. Although the system works, I have a lot of daily messages in exim's log with the following error: MYSQL connection failed: Can not connect to MySQL server on'192 .168.5.1 '(1) What causes some messages are rejected. To try to reproduce the problem I have tried doing Telnet connections to the server and MySQL, sometimes I get the following error: Telnet 192.168.5.1 3306 Trying 192.168.5.1 ... Telnet: connect to address 192.168.5.1: Operation not permitted Telnet: Unable to connect to remote host Someone could help me with this ?, thanks in advance Best regards _ News, entertainment and everything you care about at Live.com. Get it now! http://www.live.com/getstarted.aspx
Re: MYSQL connection failed: Can not connect to MySQL server
In the last episode (Oct 31), Jose Romero said: Hi,I have a mail system on FreeBSD 6.2 + Exim 4.62 + MySQL 5.0. Exim was compiled with MySQL support, the MySQL database is external to the mail server. Although the system works, I have a lot of daily messages in exim's log with the following error: MYSQL connection failed: Can not connect to MySQL server on'192 .168.5.1 '(1) What causes some messages are rejected. To try to reproduce the problem I have tried doing Telnet connections to the server and MySQL, sometimes I get the following error: Telnet 192.168.5.1 3306 Trying 192.168.5.1 ... Telnet: connect to address 192.168.5.1: Operation not permitted Telnet: Unable to connect to remote host Someone could help me with this ?, thanks in advance Best regards Do you maybe have an ipfw rule that would be blocking that? That's the only thing I can think of that will cause an EPERM error on a socket connect call. A limit rule with a too-low connection count could cause what you're seeing. Adding an explicit allow rule before your limit rule, allowing traffic to port 3306 of the other server, should fix your problem. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
error 99(?) : can't connect to MySQL server
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 connect to MySQL server on '192.168.0.200' (99) at con.pl line 14 perror 99 gives me: OS error code 99: Cannot assign requested address This doesn't make sense to me. I wrote a test script that looks like this: for (1..5) { $dbh = DBI-connect($dsn, $user, $password, {'RaiseError' = 1} ); my $sth = $dbh-prepare('SELECT * FROM users'); } Periodically I get the above error. I have tried to be more nice, after upgrading DBD and DBI, etc.: for (1..5) { $dbh = DBI-connect($dsn, $user, $password, {'RaiseError' = 1} ); my $sth = $dbh-prepare('SELECT * FROM users'); $sth = undef; $dbh-disconnect; $dbh = undef; } But the same happens. Then I straced the program. This is what I got: restart_syscall(... resuming interrupted call ...) = 0 time(NULL) = 1170758829 socket(PF_INET, SOCK_STREAM, IPPROTO_IP) = 3 fcntl64(3, F_SETFL, O_RDONLY) = 0 fcntl64(3, F_GETFL) = 0x2 (flags O_RDWR) connect(3, {sa_family=AF_INET, sin_port=htons(3306), sin_addr=inet_addr(192.168.0.200)}, 16) = -1 EADDRNOTAVAIL (Cannot assign requested address) shutdown(3, 2 /* send and receive */) = -1 ENOTCONN (Transport endpoint is not connected) close(3)= 0 write(1, Doesn\'t work. Reconnecting in 1 ..., 51) = 51 time(NULL) = 1170758829 rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0 rt_sigaction(SIGCHLD, NULL, {SIG_DFL}, 8) = 0 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0 nanosleep({1, 0}, {1, 0}) = 0 time(NULL) = 1170758830 socket(PF_INET, SOCK_STREAM, IPPROTO_IP) = 3 fcntl64(3, F_SETFL, O_RDONLY) = 0 fcntl64(3, F_GETFL) = 0x2 (flags O_RDWR) connect(3, {sa_family=AF_INET, sin_port=htons(3306), sin_addr=inet_addr(192.168.0.200)}, 16) = -1 EADDRNOTAVAIL (Cannot assign requested address) shutdown(3, 2 /* send and receive */) = -1 ENOTCONN (Transport endpoint is not connected) Anybody seen anything like this? - Fagzal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: error 99(?) : can't connect to MySQL server
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: http://www.mysqlperformanceblog.com/2006/11/12/are-php-persistent-connections-evil/ Don't be confused with the PHP mentioned, the first paragraphs apply to TCP/IP and mysql as whole. regards Nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: error 99(?) : can't connect to MySQL server
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 on that topic: http://www.mysqlperformanceblog.com/2006/11/12/are-php-persistent-connections-evil/ Don't be confused with the PHP mentioned, the first paragraphs apply to TCP/IP and mysql as whole. regards Nils Thanks, Nils. Actually I got to the same conclusion, too... when this error appears, there are something like 15000 TCP connections around, mostly in TIME_WAIT. Too bad these connections linger around even after an explicit -disconnect(). I should be using a persistent connection anyway :) - Csongor -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How can I connect to mysql server using PHP?
Hello everyone: I wanna connect to mysql server using PHP. My operating system is Redhat Fedora Core 4, and the version of mysql is 4.1.3 beta. I've started the server using a statement like this: #/usr/local/mysql/bin/mysqld -uroot -S/var/lib/mysql/mysql.sock But when I call mysql_pconnect(localhost,root,) in my web page, the server return me an error, saying Can't connect to socket:/var/lib/mysql/mysql.sock(13). How can I do? Fang -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How can I connect to mysql server using PHP?
On Tuesday 27 June 2006 03:35 am, 战芳 wrote: Hello everyone: I wanna connect to mysql server using PHP. My operating system is Redhat Fedora Core 4, and the version of mysql is 4.1.3 beta. I've started the server using a statement like this: #/usr/local/mysql/bin/mysqld -uroot -S/var/lib/mysql/mysql.sock The is what's screwing you up. takes the command /usr/local/mysql/bin/mysqld -uroot and puts it in the background. -S is simply eaten up by the shell, and probably tried as arguments to test. You probably want: /usr/local/mysql/bin/mysqld -uroot -S/var/lib/mysql/mysql.sock But when I call mysql_pconnect(localhost,root,) in my web page, the server return me an error, saying Can't connect to socket:/var/lib/mysql/mysql.sock(13). How can I do? Fang -- Chris White PHP Programmer/DB Freeloader Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: I can't connect to mysql server with PHP
战芳 wrote: Hi! gerald_clark, But when I call mysql_pconnect(localhost:3306,root,root_password),it return the same error. How can I get the permission to open /var/mysql/lib/mysql.sock? Fang what do you get when you do ls -l /var/mysql/lib/mysql.sock? Permissions should be srwxrwxrwx fool.ben wrote: Hi everybody! I've install a mysql server on my computer. 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 '/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 the following statement, there was no error occured: localhost#/usr/local/mysql/bin/mysql -uroot -S/var/mysql/lib/mysql.sock Here you are root, so you have permissions. Can anyone help me? Fix your permissions or move your socket to a directory that is world searchable. Fang -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Re: I can't connect to mysql server with PHP
Hi! gerald_clark, But when I call mysql_pconnect(localhost:3306,root,root_password),it return the same error. How can I get the permission to open /var/mysql/lib/mysql.sock? Fang fool.ben wrote: Hi everybody! I've install a mysql server on my computer. 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 '/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 the following statement, there was no error occured: localhost#/usr/local/mysql/bin/mysql -uroot -S/var/mysql/lib/mysql.sock Here you are root, so you have permissions. Can anyone help me? Fix your permissions or move your socket to a directory that is world searchable. Fang -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I can't connect to mysql server with PHP
Hi everybody! I've install a mysql server on my computer. 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 '/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/mysql.sock Can anyone help me? Fang
Re: I can't connect to mysql server with PHP
fool.ben wrote: Hi everybody! I've install a mysql server on my computer. 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 '/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 the following statement, there was no error occured: localhost#/usr/local/mysql/bin/mysql -uroot -S/var/mysql/lib/mysql.sock Here you are root, so you have permissions. Can anyone help me? Fix your permissions or move your socket to a directory that is world searchable. Fang -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ERROR 2003 (HY000): Can't connect to MySQL server on 'gandalf' (111)
Hi, I've been dealing with this problem for a week now without resolution. I'm running an application called mythtv which uses mysql as its database. I've installed mythtv and mysql dozens of times without any problem. I'd been running two Mandrake 10.1 systems for the last nine months. One, gandalf, was the mythtv backend server which also runs mysql. The other is frodo, which runs the mythtfrontend ( client ) and connects to the backend. It must also connect to the mysql DB. MySQL-4.0.20-3mdk.i586.rpm comes with the Mandrake 10.1 distribution. I don't know which version of mysql that equates to. I first installed Mandrivia 2006 on the client system, which comes with Mysql 4.1.2 ( MySQL-4.1.12-3mdk.i586.rpm ). I did an install, not an upgrade. I could still connect to gandalf with: mysql -umythtv -pmythtv -hgandalf mythconverg I then did a mysqldump 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 mythconverg using on the server gandalf: # mysql -u root mythconverg mysql grant all on mythconverg.* to mythtv@% identified by mythtv; mysql flush privileges; Still can't connect. I booted off the old installation and did a mysql dump of mysql database and did inserts of the appropriate tables, like the user table. Still can't connect. I've droped the mythconverg database, recreated a skeleton of it, granted the open privledges and still can not connect to it. Another fact: on the server gandalf, I can connect to the database as localhost, but not if I specify the host: gandalf# mysql -u mythtv -pmythtv mythconverg Success!! gandalf# mysql -u mythtv -pmythtv -h gandalf mythconvergFailure!! gandalf# mysql -u mythtv -pmythtv -h 10.0.1.40 mythconverg Failure!! gandalf# mysql -u mythtv -pmythtv -h 127.0.0.1 mythconverg Success!! gandalf# mysql -u mythtv -pmythtv -h localhost mythconverg Success!! 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: skip-innodb set-variable=thread_stack=256k to /etc/my.cnf was needed for mysql under Mandrake. Still no help. Also, I can resolve the name/ip of both hosts from both hosts. I can ping each host ( by name ) both ways. I can ssy ( by name ) between both hosts. Thanks, Mike __ Start your day with Yahoo! - Make it your home page! http://www.yahoo.com/r/hs -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 2003 (HY000): Can't connect to MySQL server on 'gandalf' (111)
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 the Unix socket. This sounds like your situation. Note that a could not connect error means just that. If the problem was related to user privileges you would get an access denied error. HTH, -Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can't connect to mysql server from another windows box
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 address. One each machine, a local client successfully connects to the local mysql server as localhost. In mysql server on the w2k box, a client row in mysql.user has been created with: user=the exact value used in the ODBC Admin dialog password=the exact value used in the ODBC Admin dialog Host=name of the machine being used as a client 'skip-networking' is not set on either machine. But when ODBCAdmin (3.51) is used to create a DSN on the winxp machine for connecting to the mysql server on the w2k machine, clicking 'Test Data Source' yields this error: Host 'XPBOX' is not allowed to connect to this MySQL server'. (Oddly, the mysql server capitalizes the name of the winxp box. Why does it do that?) Issuing the command telnet w2kbox 3306 on the xpbox also produced this same error message. This ought to be simple. What's the secret? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't connect to mysql server from another windows box
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 repsectively) The client machine can ping the server machine by name or IP address. One each machine, a local client successfully connects to the local mysql server as localhost. In mysql server on the w2k box, a client row in mysql.user has been created with: user=the exact value used in the ODBC Admin dialog password=the exact value used in the ODBC Admin dialog Host=name of the machine being used as a client 'skip-networking' is not set on either machine. But when ODBCAdmin (3.51) is used to create a DSN on the winxp machine for connecting to the mysql server on the w2k machine, clicking 'Test Data Source' yields this error: Host 'XPBOX' is not allowed to connect to this MySQL server'. (Oddly, the mysql server capitalizes the name of the winxp box. Why does it do that?) Issuing the command telnet w2kbox 3306 on the xpbox also produced this same error message. This ought to be simple. What's the secret? From your description, the mostly likely problem is that the password field of the user table is NOT a hashed password value. The authentication attempt would fail because the database is trying to compare a hashed password (coming from your ODBC driver) to a non-hashed value. Use the PASSWORD() function to hash a plain-text password for the user so that it will match the authentication attempt from the driver update mysql.user set password = PASSWORD(`password`) WHERE user = 'odbclogin'; http://dev.mysql.com/doc/mysql/en/encryption-functions.html A second reason could be because the MySQL ODBC driver is acting as a PRE-4.1 client (it is using the shorter password hashes that existed before v4.1). update mysql.user set password = OLD_PASSWORD('plaintext_of_password') WHERE user = 'odbclogin'; http://dev.mysql.com/doc/mysql/en/old-client.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: Can't connect to mysql server from another windows box
[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 machine (xp and w2kpro repsectively) The client machine can ping the server machine by name or IP address. One each machine, a local client successfully connects to the local mysql server as localhost. In mysql server on the w2k box, a client row in mysql.user has been created with: user=the exact value used in the ODBC Admin dialog password=the exact value used in the ODBC Admin dialog Host=name of the machine being used as a client 'skip-networking' is not set on either machine. But when ODBCAdmin (3.51) is used to create a DSN on the winxp machine for connecting to the mysql server on the w2k machine, clicking 'Test Data Source' yields this error: Host 'XPBOX' is not allowed to connect to this MySQL server'. (Oddly, the mysql server capitalizes the name of the winxp box. Why does it do that?) Issuing the command telnet w2kbox 3306 on the xpbox also produced this same error message. This ought to be simple. What's the secret? From your description, the mostly likely problem is that the password field of the user table is NOT a hashed password value. The authentication attempt would fail because the database is trying to compare a hashed password (coming from your ODBC driver) to a non-hashed value. Use the PASSWORD() function to hash a plain-text password for the user so that it will match the authentication attempt from the driver update mysql.user set password = PASSWORD(`password`) WHERE user = 'odbclogin'; http://dev.mysql.com/doc/mysql/en/encryption-functions.html A second reason could be because the MySQL ODBC driver is acting as a PRE-4.1 client (it is using the shorter password hashes that existed before v4.1). update mysql.user set password = OLD_PASSWORD('plaintext_of_password') WHERE user = 'odbclogin'; http://dev.mysql.com/doc/mysql/en/old-client.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine Note that if you set the password by directly editing (UPDATE) the mysql.user table like this, you will have to run FLUSH PRIVILEGES; afterward to make the change take effect. Alternatively, you can set the password with SET PASSWORD FOR 'odbclogin'@'xpbox' = PASSWORD('odbc_pass'); or SET PASSWORD FOR 'odbclogin'@'xpbox' = OLD_PASSWORD('odbc_pass'); or even GRANT USAGE ON *.* TO 'odbclogin'xpbox'%' IDENTIFIED BY 'odbc_pass'; FLUSH PRIVILEGES is not necessary sfter any of these. See the manual for the details http://dev.mysql.com/doc/mysql/en/passwords.html. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't connect to mysql server from another windows box
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 an 'authentication protocol' message. Apparently Connector/ODBC 3.51 uses the old protocol. Gerald Williams -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't connect to mysql server from another windows box
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 access table(s). so, if you've put xpbox.domain.xxx in the access table but the lookup on the inbound IPnumber only returns xpbox (which is technically an invalid entry anyway) things will fail. so, do lookups on the IPnumbers of the client machines and see what's returned. that's what you want in the mysql access tables. Flushing privileges permitted a connection from the mysql client. To get the ODBC Admin 'Test Data Source' button to work, I had to create a user table entry with a password hashed by Old_Password(). Is ipconfig /all what you mean by lookup on the IPnumbers? That gives the name of the client box without domain.xxx. In any event, the 'technically incorrect' name did work, and adding the domain.xxx part of the name to the user record did not work. Gerald Williams Host=name of the machine being used as a client 'skip-networking' is not set on either machine. But when ODBCAdmin (3.51) is used to create a DSN on the winxp machine for connecting to the mysql server on the w2k machine, clicking 'Test Data Source' yields this error: Host 'XPBOX' is not allowed to connect to this MySQL server'. (Oddly, the mysql server capitalizes the name of the winxp box. Why does it do that?) Issuing the command telnet w2kbox 3306 on the xpbox also produced this same error message. This ought to be simple. What's the secret? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- End Original Message -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can not connect to Mysql server with Number 2003
All, In a few minutes ago, I can connect to mysql. Log out and can not login with error Mysql error Number 2003 can't connect to Mysql server.. Any idea, please help! Thank you..Nguyen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can not connect to Mysql server with Number 2003
Nguyen, Phong wrote: All, In a few minutes ago, I can connect to mysql. Log out and can not login with error Mysql error Number 2003 can't connect to Mysql server.. Check this: http://dev.mysql.com/doc/mysql/en/access-denied.html It is a good idea, for now, to check the error logs, there should be an explanation about how the server crashed Any idea, please help! Thank you..Nguyen -- Nuno Pereira -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can not connect to Mysql server with Number 2003
Hello. See: http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html Nguyen, Phong [EMAIL PROTECTED] wrote: All, In a few minutes ago, I can connect to mysql. Log out and can not login with error Mysql error Number 2003 can't connect to Mysql server.. Any idea, please help! Thank you..Nguyen -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Not able to connect to Mysql server from network machine
Hello. Check with netstat if MySQL is listening on 3306 port on the server. Use traffic analyzers to see if your packets reach the server. Enable the general query log on the server to see if server receives your requests to connect. See: http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html http://dev.mysql.com/doc/mysql/en/query-log.html Reema Troiana [EMAIL PROTECTED] wrote: Hi All, I'm trying to connect to MySql server from MySql Administrator on a network machine. I specify the Server host as IP of the machine where DB server is running and Port as 3306. Username as 'root' and the password I have tried with other usernames and specifying machine name instead of IP. It doesn't work in any case. But i always get this error: Could not connect to the specififed instance. MySQL Error number 2003 and it says: If you want to check network connection, please ping When i click ping i get reply from the machine i'm trying to connect to I'm able to connect to localhost, i.e., if i have the DB server on the same machine. MySql server is running on XP machine. Is there any option that i have to enable to make network machine to log on to Mysql DB server?? I'll appreciate any help. Thanks, Reema -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Not able to connect to Mysql server from network machine
Hi All, I'm trying to connect to MySql server from MySql Administrator on a network machine. I specify the Server host as IP of the machine where DB server is running and Port as 3306. Username as 'root' and the password I have tried with other usernames and specifying machine name instead of IP. It doesn't work in any case. But i always get this error: Could not connect to the specififed instance. MySQL Error number 2003 and it says: If you want to check network connection, please ping When i click ping i get reply from the machine I'm trying to connect to I'm able to connect to localhost, i.e., if i have the DB server on the same machine. MySql server is running on XP machine. Is there any option that i have to enable to make network machine to log on to Mysql DB server?? I'll appreciate any help. Thanks, Reema Duggal Troiana Senior Software Developer BitArmor Systems, Inc. 357 North Craig Street Ground Floor Pittsburgh, PA 15213 [TEL] 412-682-2200 Ext 314 [FAX] 412-682-2201
Re: Not able to connect to Mysql server from network machine
rtroiana [EMAIL PROTECTED] wrote on 06/06/2005 08:42:18 AM: Hi All, I'm trying to connect to MySql server from MySql Administrator on a network machine. I specify the Server host as IP of the machine where DB server is running and Port as 3306. Username as 'root' and the password I have tried with other usernames and specifying machine name instead of IP. It doesn't work in any case. But i always get this error: Could not connect to the specififed instance. MySQL Error number 2003 and it says: If you want to check network connection, please ping When i click ping i get reply from the machine I'm trying to connect to I'm able to connect to localhost, i.e., if i have the DB server on the same machine. MySql server is running on XP machine. Is there any option that i have to enable to make network machine to log on to Mysql DB server?? I'll appreciate any help. Thanks, Reema Duggal Troiana Senior Software Developer BitArmor Systems, Inc. 357 North Craig Street Ground Floor Pittsburgh, PA 15213 [TEL] 412-682-2200 Ext 314 [FAX] 412-682-2201 Not everyone works or lurks on the weekends. Have you tried to RTFM? http://dev.mysql.com/doc/mysql/en/post-installation.html http://dev.mysql.com/doc/mysql/en/problems.html (especially) http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html (and) http://dev.mysql.com/doc/mysql/en/starting-server.html Use the TELNET test connection method (described in the readings) to verify you have a working network path from your remote server to the MySQL server. By the domain in your return address, I believe you work for someone who is more likely than not to have several restrictions on your network traffic. Anything that prevents traffic through port 3306 (unless you told your MySQL daemon to use a different port) between your two machines will prevent your connection. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: Not able to connect to Mysql server from network machine
Thanks Gleb. I just had to manually make changes in my firewall. I allowed requests to port 3306 mysqld.exe in exceptions tab and it solved the problem. The only reason I didn't think about firewall setting before since whenever I try to run new service, I wud get a pop up from Firewall asking to allow the service or not. Thanks, Reema
Not able to connect to Mysql server from network machine
Hi All, I'm trying to connect to MySql server from MySql Administrator on a network machine. I specify the Server host as IP of the machine where DB server is running and Port as 3306. Username as 'root' and the password I have tried with other usernames and specifying machine name instead of IP. It doesn't work in any case. But i always get this error: Could not connect to the specififed instance. MySQL Error number 2003 and it says: If you want to check network connection, please ping When i click ping i get reply from the machine i'm trying to connect to I'm able to connect to localhost, i.e., if i have the DB server on the same machine. MySql server is running on XP machine. Is there any option that i have to enable to make network machine to log on to Mysql DB server?? I'll appreciate any help. Thanks, Reema -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connect to MYSQL server from Wi-Fi enabled Windows CE device
Please don't respond directly to me if you have further questions, as you would probably be more likely to get better help from the list. It sounds like a typical database connection? What is your problem? What are the errors you are getting? All you have said so far is that you need help, and here is how you are doing it. If you can get a TCP/IP connection on the mobile device, you should be good to go. j- k- On Tuesday 01 March 2005 22:44, you said something like: Thank you for your Reply, Yes I have a TCP/IP connection on the WinCE device. My VB application on the ipaq gets its data from a DB on the device. I use ADOCE to connect to this DB, this DB on the device synchronizes with a MYSQL DB, and currently I have a desktop application that handles the synchronization. This means I physically plug in to a desktop PC with a USB cable and then sync the 2 DBs. So what I want to do is move the sync app to the CE Device and connect to MYSQL directly from the mobile device. Hope this gives you a better idea of the problem. Regards Hough Joshua J. Kugler [EMAIL PROTECTED] 03/02/05 9:07 AM On Wednesday 23 February 2005 03:47, Hough Van Wyk said something like: I am developing a embedded VB application running on a hp ipaq running Windows CE 2003. This app has to connect to a MYSQL DB over a wireless network. I have surfed the internet for hours with no luck. Can anyone please help me with this problem. What exactly is your problem? Do you have a TCP/IP connection on the WinCE device? Will the MySQL ODBC drivers run on the device (or does your programming environment have its own drivers, such as the light-weight drivers for VB)? What have your tried? If it's a standard ethernet connection, there is no difference than if you were plugged into a wall. What exactly are you looking for in your search? j- k- -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connect to MYSQL server from Wi-Fi enabled Windows CE device
On Wednesday 23 February 2005 03:47, Hough Van Wyk said something like: I am developing a embedded VB application running on a hp ipaq running Windows CE 2003. This app has to connect to a MYSQL DB over a wireless network. I have surfed the internet for hours with no luck. Can anyone please help me with this problem. What exactly is your problem? Do you have a TCP/IP connection on the WinCE device? Will the MySQL ODBC drivers run on the device (or does your programming environment have its own drivers, such as the light-weight drivers for VB)? What have your tried? If it's a standard ethernet connection, there is no difference than if you were plugged into a wall. What exactly are you looking for in your search? j- k- -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Connect to MYSQL server from Wi-Fi enabled Windows CE device
Hi All, I am developing a embedded VB application running on a hp ipaq running Windows CE 2003. This app has to connect to a MYSQL DB over a wireless network. I have surfed the internet for hours with no luck. Can anyone please help me with this problem. Regards Hough -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Error connecting to master: Can't connect to MySQL server on 'IPADDR # MUST BE SET' (111)
Hi, I am trying to setup replication on MySQL. Version 4.1.0alpha Using: ./bin/mysql -h IPADDR -u replication -p I can connect successfully, but my error logs show 041221 1:12:41 Slave I/O thread: error connecting to master 'replication # MU@IPADDR # MUST BE SET:3306': Error: 'Can't connect to MySQL server on 'IPADDR # MUST BE SET' (111)' errno: 2003 retry-time: 60 retries: 86400 Google hasnt turned up anything useful. Any ideas anyone? What am I doing wrong. Master # The MySQL server [mysqld] server-id=1 log-bin Slave # The MySQL server [mysqld] server-id=9 master-host=IPADDR master-port= master-user=replication master-password=password show master status bin.0001 position: 4486513 thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error connecting to master: Can't connect to MySQL server on 'IPADDR # MUST BE SET' (111)
Hello. When you are connecting using mysql, you usually don't specify the destination port. By default it's 3306. And at the same time master-port=. Send us complete contents of config files. What is in master error log? Check to what port slave instance is trying to connect (with tcpdump, netstat for example). Terence [EMAIL PROTECTED] wrote: Hi, I am trying to setup replication on MySQL. Version 4.1.0alpha Using: ./bin/mysql -h IPADDR -u replication -p I can connect successfully, but my error logs show 041221 1:12:41 Slave I/O thread: error connecting to master 'replication # MU@IPADDR # MUST BE SET:3306': Error: 'Can't connect to MySQL server on 'IPADDR # MUST BE SET' (111)' errno: 2003 retry-time: 60 retries: 86400 Google hasnt turned up anything useful. Any ideas anyone? What am I doing wrong. Master # The MySQL server [mysqld] server-id=1 log-bin Slave # The MySQL server [mysqld] server-id=9 master-host=IPADDR master-port= master-user=replication master-password=password show master status bin.0001 position: 4486513 thanks! -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error connecting to master: Can't connect to MySQL server on 'IPADDR # MUST BE SET' (111)
I found that restarting the mysql server does not recreate the master.info file in the data directory. Although I had changed some settings in the /etc/my.cnf they did not populate the master.info file. So after banging my head for so many hours I deleted the master.info file and restarted the server. So that's where the # MU came from. On a seperate note for those experiencing problems on error 1189 Net error reading from master - the problem appears to be innodb tables which are not supported by LOAD TABLE FROM MASTER. That's going to be an extremely tough one to get around. Thanks Gleb for your help. Gleb Paharenko wrote: Hello. When you are connecting using mysql, you usually don't specify the destination port. By default it's 3306. And at the same time master-port=. Send us complete contents of config files. What is in master error log? Check to what port slave instance is trying to connect (with tcpdump, netstat for example). Terence [EMAIL PROTECTED] wrote: Hi, I am trying to setup replication on MySQL. Version 4.1.0alpha Using: ./bin/mysql -h IPADDR -u replication -p I can connect successfully, but my error logs show 041221 1:12:41 Slave I/O thread: error connecting to master 'replication # MU@IPADDR # MUST BE SET:3306': Error: 'Can't connect to MySQL server on 'IPADDR # MUST BE SET' (111)' errno: 2003 retry-time: 60 retries: 86400 Google hasnt turned up anything useful. Any ideas anyone? What am I doing wrong. Master # The MySQL server [mysqld] server-id=1 log-bin Slave # The MySQL server [mysqld] server-id=9 master-host=IPADDR master-port= master-user=replication master-password=password show master status bin.0001 position: 4486513 thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can't connect to MySQL server - Operation now in progress
Hi, I'm noticing this error in various script of ours that run on the cron: DBI connect('general:10.1.1.80:3306;mysql_connect_timeout=3','root',...) failed: Can't connect to MySQL server on '10.1.1.80' (115) at /usr/local/apache/cgi-bin/Shared/DBStuff.pm line 214 This happens on a number of our servers, in different hosting centres, connecting to different database servers, running different versions of MySQL, so I don't think this points to any specific hardware/software/network issues. One set of servers are running Red Hat Linux versions 6.2 to RHEL 2.1, networked over 10/100 ethernet, connecting to MySQL on a remote host (version 3.22.32) via Perl DBD::mysql. Another set of servers are running Red Hat Enterprise Linux 2.1, networked over 10/100 ethernet, connecting to MySQL on a remote host (version 3.23.55) via Perl DBD::mysql. The third set of servers are running Fedora Core 1, networked over gigabit copper ethernet, connecting to MySQL on a remote host (version 4.0.20) via perl DBD::mysql. Any advice or pointers anyone can give on this would be greatly appreciated. Regards, -- Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Q: Can't Connect to MySql Server
Hello, I am from Indonesia and newbie in Mysql. Why if I execute command MySql in dos prompt, appear in screen ERROR 2003 : Can't connect to MySql Server on 'localhost' (10061) Thanks Dani - Do you Yahoo!? Yahoo! Mail SpamGuard - Read only the mail you want.
Re: Q: Can't Connect to MySql Server
At 17:58 -0800 2/24/04, Danny Pudianto wrote: Hello, I am from Indonesia and newbie in Mysql. Why if I execute command MySql in dos prompt, appear in screen ERROR 2003 : Can't connect to MySql Server on 'localhost' (10061) Did you start the server (mysqld) first? -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can't connect to MySQL server on 'localhost' (10061)- solution pls
Hi all, I have the following settings in *my.ini* (obtined from WinMySQLadmin) #This File was made using the WinMySQLAdmin 1.4 Tool #12/11/2003 10:50:28 AM #Uncomment or Add only the keys that you know how works. #Read the MySQL Manual for instructions [mysqld] basedir=C:/Program Files/mysql #bind-address=192.168.2.5 datadir=C:/Program Files/mysql/data language=C:/Program Files/mysql/share/english #slow query log#= #tmpdir#= port=3306 set-variable=key_buffer=16M [client] host=127.0.0.1 port=3306 #socket=MySQL [WinMySQLadmin] Server=C:/Program Files/mysql/bin/mysqld.exe user=nura password=*** QueryInterval=10 WIth this settings I'm trying to establish connection to MySQL from COBOL. In COBOL I have the option to call C function as external subroutines. So I have coded in COBOL to invoke the C API provided from MySQL. I have just coded for mysql_init() and mysql_real_connect(). after the execution of mysql_real_connect(), i met the error message as; *Can't connect to MySQL server on 'localhost' (10061)* I have searched in various discussion forums, the points obtained never able to solve my problem. I have tested with mysqladmin as; C:\mysqladmin -h localhost --port=3306 version mysqladmin Ver 8.40 Distrib 4.0.17, for Win95/Win98 on i32 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 4.0.17-max-debug Protocol version10 Connection localhost via TCP/IP TCP port3306 Uptime: 25 min 39 sec Threads: 2 Questions: 165 Slow queries: 0 Opens: 7 Flush tables: 1 Open tables: 1 Queries per second avg: 0.107 Memory in use: 16597K Max memory used: 16627K Is anyone suggest me to come out from this trouble... thanks in advance... Regards, Arun. Yahoo! India Mobile: Download the latest polyphonic ringtones. Go to http://in.mobile.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't connect to MySQL server on 'localhost' (10061)
Your password is wrong. You probably need to read the manual that is in the docs directory. There are some issues about passwords with 4.1.1. I don't have time to walk you through the entire setup, but will be glad to help with simple questions. Since you can connect on the server, the install should be fine. There is no setup program. You just unzip it to your hard drive. Use mysqlCC or some other tool on the server to change users/passwords. This is in the mysql.user table. Make sure that the host column is set to % and not just localhost also. mysql test -h localhost -u username -ppasswd - Access denied using PW (YES) --I would delte the my.ini file(don't know if 4.1.1 even uses that)I don't use one. --the reason you can connect from localhost is because a password is not set. --search for all issues regarding passwords with 4.1.1(docs,readme's,release notes/known issues) hope this helps brian [EMAIL PROTECTED] wrote: OK. Thanks. Late now, and laptop is off. Client is the mysql.exe program. I have to copy the mysql.exe to the laptop (or cd to the server machine and execute from it. Leave the space out. Right now, just fooling around from the server machine: mysql test -h localhost - works fine. mysql test -h localhost -u username - works fine mysql test -h localhost -u username -ppasswd - Access denied using PW (YES) I use the pw that is in the my.ini Using any of the above fails to allow connection using the laptop--but I'll try again tomorrow. I suspect I did something wrong in the install, though everything seems to work from the host machine. I unzipped the the 4.1.1 catalog in winzip, read the readme that said run setup. There was no setup so I simply unzipped to the \temp directory. I ran mysqladmin, mysql, the mysqlcc (control center) and all worked. It did not install like a 'regular' program (put itself in the add software list in control panel), so I simply moved all the files to a mysql directory and everything continued to work. Had to be too simple. Well, I'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 'localhost' (10061) I've executed the mysql -h ip -u user -p pw No space after -p. I know it's weird, but it's the only way it will work. So, use this: mysql -h ip -u user -ppw With the result that I get asked for a PW and then told I can't connect. You shouldn't get asked for PW if you use the above syntax correctly. But, I don't have the 4.1.1 client. Where is it? If you downloaded mysql4.1.1 to your laptop, then you have it. Otherwise: http://www.mysql.com/downloads/mysql-4.1.html There is no '...client' in the bin directory. By client, I mean the mysql file in the bin dir. If you set your system path, you won't need to actually be in the bin dir. Otherwise you need to cd to that dir. So the entire proc is: 1.Open command prompt. 2.cd C:\mysql\bin 3.mysql -h ip -u user -ppw -- This mail composed and sent using Mozilla Thunderbird. (http://www.mozilla.org/projects/thunderbird/) -It's a brave, GNU world!(sorry Bill)-- http://www.linux.org OpenSource is aimed at skilled users, not the 3l33T3 war3z crowd. (1f U sp3ll l1k3 th1s, gu3ss wh1ch U R) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can't connect to MySQL server on 'localhost' (10061)
With several others, I too have this problem. MySQL 4.1.1 installed without a problem. The sqlAdmin is running. I can run the control center and/or mysql to do sql things. This, though, is all from the server (a PC running Win ME). I want to connect from my laptop. What do I have to do? Executing telnet to the PC won't work (probably need the a telnet server). When I move to the shared directory on the PC and try to execute mysql, I get the error. Thanks for an assistance. N. Chris Frost
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 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 installed without a problem. The sqlAdmin is running. I can run the control center and/or mysql to do sql things. This, though, is all from the server (a PC running Win ME). I want to connect from my laptop. What do I have to do? Executing telnet to the PC won't work (probably need the a telnet server). When I move to the shared directory on the PC and try to execute mysql, I get the error. Thanks for an assistance. N. Chris Frost -- Brian Harris Application Developer OptData Inc./ATRS [EMAIL PROTECTED] (501)907.5912 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't connect to MySQL server on 'localhost' (10061)
I've executed the mysql -h ip -u user -p pw No space after -p. I know it's weird, but it's the only way it will work. So, use this: mysql -h ip -u user -ppw With the result that I get asked for a PW and then told I can't connect. You shouldn't get asked for PW if you use the above syntax correctly. But, I don't have the 4.1.1 client. Where is it? If you downloaded mysql4.1.1 to your laptop, then you have it. Otherwise: http://www.mysql.com/downloads/mysql-4.1.html There is no '...client' in the bin directory. By client, I mean the mysql file in the bin dir. If you set your system path, you won't need to actually be in the bin dir. Otherwise you need to cd to that dir. So the entire proc is: 1.Open command prompt. 2.cd C:\mysql\bin 3.mysql -h ip -u user -ppw -- This mail composed and sent using Mozilla Thunderbird. (http://www.mozilla.org/projects/thunderbird/) -It's a brave, GNU world!(sorry Bill)- http://www.linux.org OpenSource is aimed at skilled users, not the 3l33T3 war3z crowd. (1f U sp3ll l1k3 th1s, gu3ss wh1ch U R) : Thanks for the reply. I've executed the mysql -h ip -u user -p pw With the result that I get asked for a PW and then told I can't connect. But, I don't have the 4.1.1 client. Where is it? There is no '...client' in the bin directory. Thanks, Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, 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 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 installed without a problem. The sqlAdmin is running. I can run the control center and/or mysql to do sql things. This, though, is all from the server (a PC running Win ME). I want to connect from my laptop. What do I have to do? Executing telnet to the PC won't work (probably need the a telnet server). When I move to the shared directory on the PC and try to execute mysql, I get the error. Thanks for an assistance. N. Chris Frost -- -- This mail composed and sent using Mozilla Thunderbird. (http://www.mozilla.org/projects/thunderbird/) -It's a brave, GNU world!(sorry Bill)-- http://www.linux.org OpenSource is aimed at skilled users, not the 3l33T3 war3z crowd. (1f U sp3ll l1k3 th1s, gu3ss wh1ch U R) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 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 installed without a problem. The sqlAdmin is running. I can run the control center and/or mysql to do sql things. This, though, is all from the server (a PC running Win ME). I want to connect from my laptop. What do I have to do? Executing telnet to the PC won't work (probably need the a telnet server). When I move to the shared directory on the PC and try to execute mysql, I get the error. Thanks for an assistance. N. Chris Frost -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql Installation on Linux: ERROR 2002: Can't connect tolocal MySQL server
Weird. I cannot find the my.cnf (configuration file).. How that's possible? Thanks From: Victor Medina [EMAIL PROTECTED] To: Mike Mapsnac [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Mysql Installation on Linux: ERROR 2002: Can't connect tolocal MySQL server th Date: Sun, 18 Jan 2004 10:24:53 -0400 Probably your server is not using any sockets, check out your my.cnf. man mysql to see how to connect to a ip based mysql host. C/ya! On Sat, 2004-01-17 at 18:51, Mike Mapsnac wrote: I just install MYSQL on Linux (Red Hat 9) using this manual:http://www.mysql.com/doc/en/Installing_binary.html Have no idea what's wrong. I looked on the mysql.log file and the file is empty. ERROR MESSAGE: [EMAIL PROTECTED] bin]# ./mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) [EMAIL PROTECTED] bin]# ./mysql status ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' _ Scope out the new MSN Plus Internet Software optimizes dial-up to the max! http://join.msn.com/?pgmarket=en-uspage=byoa/plusST=1 -- |...| | _ _|Victor Medina M | |\ \ \| | _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_|_| /_/ \_\|ext. 325 | ||geek by nature - linux by choice | |...| ... Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. Rich Cook _ Check out the new MSN 9 Dial-up fast reliable Internet access with prime features! http://join.msn.com/?pgmarket=en-uspage=dialup/homeST=1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)
Thanks for responding randy. so I checked my my.ini file and the address is set to 127.0.0.1. I checked the database error file and it was empty. I posted the my.ini file down below. Any other suggestions ? When I try to startmysql through the MSDOS prompt it says C:\Program Files\EasyPHP1-7\mysql\binmysql 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 list of available options # This will be passed to all mysql clients [client] #password=my_password port=3306 #socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] skip-innodb bind-address=127.0.0.1 port=3306 #socket=MySQL skip-locking set-variable = key_buffer=16K set-variable = max_allowed_packet=1M set-variable = thread_stack=64K set-variable = table_cache=4 set-variable = sort_buffer=64K set-variable = net_buffer_length=2K server-id = 1 # Uncomment the following if you want to log updates #log-bin # Uncomment the following rows if you move the MySQL distribution to another # location basedir = C:/Program Files/EasyPHP1-7/mysql/ datadir = C:/Program Files/EasyPHP1-7/mysql/data/ # Uncomment the following if you are NOT using BDB tables #skip-bdb # Uncomment the following if you are using Innobase tables #innodb_data_file_path = ibdata1:100M #innodb_data_home_dir = c:\ibdata #innodb_log_group_home_dir = c:\iblogs #innodb_log_arch_dir = c:\iblogs #set-variable = innodb_mirrored_log_groups=1 #set-variable = innodb_log_files_in_group=3 #set-variable = innodb_log_file_size=5M #set-variable = innodb_log_buffer_size=8M #innodb_flush_log_at_trx_commit=1 #innodb_log_archive=0 #set-variable = innodb_buffer_pool_size=16M #set-variable = innodb_additional_mem_pool_size=2M #set-variable = innodb_file_io_threads=4 #set-variable = innodb_lock_wait_timeout=50 [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] set-variable = key_buffer=8M set-variable = sort_buffer=8M [myisamchk] set-variable = key_buffer=8M set-variable = sort_buffer=8M [mysqlhotcopy] interactive-timeout Randy Clamons [EMAIL PROTECTED] wrote: Check your my.ini (in c:\WINNT or c:\windows) for the bind-address. To force TCP connection the address should be set to 127.0.0.1. When connecting from PHP, connect to 127.0.0.1 instead of localhost. Specifying localhost as the address attempts to connect with named pipe. Also, check your [database].err file (located in the mysql/data folder) for any errors while starting the server. Randy At 11:32 AM 01/12/2004 -0800, you wrote: So I recently removed firepages PHP 4.0, and then installed the EasyPHP package 1.7(MYSQL, APACHE, PHP) . When it starts up everything runs except MYSQL the program is installed in the C:Program files- EASY PHP1.7- MYSQL. I recieve the following error, Can't connect to MySQL server on 'localhost' (10061) Do I need to change the port setting? or do I need to install in the C:/ folder? any advice is muchly appreciated. rich - Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes Thanks for using Astro-Auction.com. Randy Clamons Systems Programming - Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
Can't connect to MySQL server
I'm new to the list, hope this is the correct mailing list. 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 I can also connect through phpmyadmin (remotely or locally). http://xxx.168.xxx.xxx/phpmyadmin/ but I can't connect if I put in the IP address (locally or remotely) mysql -h xxx.168.xxx.xxx -p password: ERROR 2003: Can't connect to MySQL server on 'xxx.168.xxx.xxx' (22) --- locally ERROR 2003: Can't connect to MySQL server on 'xxx.168.xxx.xxx' (61) -- remotely I've looked all through the documentation from MySQL and the archives on the web. From looking at the docs, it seems that my problem either lies in how the user accounts are set up for how the server is set up. My guess is the user accounts. I've set up the user to be able to connect from anywhere. Summary(user: xxx, host: %, password: Yes, privileges: ALL PRIVILEGES , grant: Yes). I used phpmyadmin to set up the accounts. Thanks in advance, Aaron- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't connect to MySQL server
* 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 line 'skip-networking' from /etc/mysql/my.cnf, type /etc/init.d/mysql restart and try connecting to the IP address again. -- Johannes Franken MySQL Professional mailto:[EMAIL PROTECTED] http://www.jfranken.de/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't connect to MySQL server
* 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 using the -u parameter. The user you are logging in with will be the user of your current linux session. root? I can also connect through phpmyadmin (remotely or locally). http://xxx.168.xxx.xxx/phpmyadmin/ This is a different type of connection. A web server is running on xxx.168.xxx.xxx, phpmyadmin is installed on it. You are connecting to the web server with your browser. but I can't connect if I put in the IP address (locally or remotely) mysql -h xxx.168.xxx.xxx -p password: ERROR 2003: Can't connect to MySQL server on 'xxx.168.xxx.xxx' (22) --- locally ERROR 2003: Can't connect to MySQL server on 'xxx.168.xxx.xxx' (61) -- remotely You don't use the -u parameter. This means the current user name is used. Did you try this logged in to linux as a user named xxx? (Where 'xxx' is the name you have defined in phpmyadmin) I've looked all through the documentation from MySQL and the archives on the web. From looking at the docs, it seems that my problem either lies in how the user accounts are set up for how the server is set up. My guess is the user accounts. I've set up the user to be able to connect from anywhere. Summary(user: xxx, host: %, password: Yes, privileges: ALL PRIVILEGES , grant: Yes). I used phpmyadmin to set up the accounts. With this setup, the user xxx should be able to log in from any host, but you should use -u xxx when you start the mysql client: mysql -h xxx.168.xxx.xxx -u xxx -p Note that there are two ways to connect to the mysql server: using sockets (or named pipes on windows) or using TCP/IP. If you provide -h hostname-or-ip-address a TCP/IP connection is used, if you provide -h localhost or no -h parameter, a unix socket is used. You are not running the server with --skip-networking, are you? If you are, TCP/IP support is disabled. Have you configured the server to use a non-standard port (different from 3306)? In that case, you must provide port number when starting the client: mysql -h xxx.168.xxx.xxx --port=3307 -u xxx -p URL: http://www.mysql.com/doc/en/Can_not_connect_to_server.html -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't connect to MySQL server
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. Thanks again. Aaron- On Jan 10, 2004, at 3:20 PM, Johannes Franken wrote: * 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 line 'skip-networking' from /etc/mysql/my.cnf, type /etc/init.d/mysql restart and try connecting to the IP address again. On Jan 10, 2004, at 3:30 PM, Roger Baklund wrote: Note that there are two ways to connect to the mysql server: using sockets (or named pipes on windows) or using TCP/IP. If you provide -h hostname-or-ip-address a TCP/IP connection is used, if you provide -h localhost or no -h parameter, a unix socket is used. You are not running the server with --skip-networking, are you? If you are, TCP/IP support is disabled. Have you configured the server to use a non-standard port (different from 3306)? In that case, you must provide port number when starting the client: mysql -h xxx.168.xxx.xxx --port=3307 -u xxx -p -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
problem trying to connect to MySQL server
I'm having a problem with one of our MySQL servers. Setup VPN with Firewall at main office (iptables), remote office currently has 2 MySQL servers and their port numbers are 3306 (server1) and 3309 (server2) Programmer accesses server1 okay from his location, but cannot access server2. He will be moving data from server1 to the new server2. Error msg: error no. Can't conect to mysql server at '192.168.0.15' (10061). Thanks -- Jon Miller [EMAIL PROTECTED] MMT Networks Pty Ltd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: problem trying to connect to MySQL server
Maybe port 3309 is not open on the firewall or there is no rule set for it or it is blocked. I am not a network expert though!!! Thanks Emery - Original Message - From: Jon Miller [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Monday, December 29, 2003 13:44 Subject: problem trying to connect to MySQL server I'm having a problem with one of our MySQL servers. Setup VPN with Firewall at main office (iptables), remote office currently has 2 MySQL servers and their port numbers are 3306 (server1) and 3309 (server2) Programmer accesses server1 okay from his location, but cannot access server2. He will be moving data from server1 to the new server2. Error msg: error no. Can't conect to mysql server at '192.168.0.15' (10061). Thanks -- Jon Miller [EMAIL PROTECTED] MMT Networks Pty Ltd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't connect to MySQL server on '[server]' (10061) - unix tcp/ip sockets
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 SQLyog (from Windows) I get the same error (near enough) from both: SQLyog: --- SQLyog --- Error No. 2003 Can't connect to MySQL server on '[server]' (10061) --- MySQL Control Center: [server] ERROR 2003: Can't connect to MySQL server on '[server]' (10061) Searching through the mysql.com documentation led me to http://www.mysql.com/doc/en/Can_not_connect_to_server.html, which talks about unix and tcp/ip sockets. Running mysqladmin version gives me the following output: mysqladmin Ver 8.40 Distrib 4.0.13, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 4.0.13-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/run/mysqld/mysqld.sock Uptime: 2 hours 6 min 24 sec Threads: 3 Questions: 450 Slow queries: 0 Opens: 16 Flush tables: 1 Open tables: 5 Queries per second avg: 0.059 Since the documentation (I forget where) showed the version output showing the tcp port the server was running on (and mine doesn't), I am led to believe the server isn't running on a tcp/ip socket. From what I can tell though, my.cnf does have the necessary lines for doing this - port=3306 (as per default) is in there, uncommented-out. Can anyone suggest what I might need to change in my configuration to enable tcp/ip connections? All the search results I've seen so far appear only to relate to people running MySQL (server) under windows... Did you run MySQL server with --skip-networking option? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can't connect to MySQL server on '[server]' (10061) - unix tcp/ip sockets
Hi, 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 SQLyog (from Windows) I get the same error (near enough) from both: SQLyog: --- SQLyog --- Error No. 2003 Can't connect to MySQL server on '[server]' (10061) --- MySQL Control Center: [server] ERROR 2003: Can't connect to MySQL server on '[server]' (10061) Searching through the mysql.com documentation led me to http://www.mysql.com/doc/en/Can_not_connect_to_server.html, which talks about unix and tcp/ip sockets. Running mysqladmin version gives me the following output: mysqladmin Ver 8.40 Distrib 4.0.13, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 4.0.13-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/run/mysqld/mysqld.sock Uptime: 2 hours 6 min 24 sec Threads: 3 Questions: 450 Slow queries: 0 Opens: 16 Flush tables: 1 Open tables: 5 Queries per second avg: 0.059 Since the documentation (I forget where) showed the version output showing the tcp port the server was running on (and mine doesn't), I am led to believe the server isn't running on a tcp/ip socket. From what I can tell though, my.cnf does have the necessary lines for doing this - port=3306 (as per default) is in there, uncommented-out. Can anyone suggest what I might need to change in my configuration to enable tcp/ip connections? All the search results I've seen so far appear only to relate to people running MySQL (server) under windows... Cheers, Ben Darlow ---Disclaimer--- Unless obviously public, this email is confidential to the intended recipient(s). If you received it in error please tell the sender and then delete it. We check emails from dyslexic.com and iansyst.co.uk, but you should virus check incoming emails. Emails do not always represent our official policy or a contract. Errors and omissions are excepted. iANSYST Ltd, Fen House, Fen Road, CAMBRIDGE, CB4 1UN. T +44(0)1223 420101; Fax +44(0) 1223 42 66 44; [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Re: cant connect to mysql server through socket
Did you build mysql yourself, or did you install it along with Suse? If it's installed with suse, start the mysql service via the suse method (not sure what that is, on RedHat, one would simply say service mysqld start). If you built it by installing the binary, then your mysql should be located in /usr/local/mysql to start, cd to that folder and say bin/mysqld_safe (for 4.x) or bin/safe_mysqld (for 3.x) Also, if you installed the binary, make sure the folder that contains the mysql files ( /usr/local/mysql is a symlink to the actual location) is owned by mysql user (chown -R mysql.mysql /path/to/files From the sounds of things however, it looks like you are trying to use the version that came with suse. For that, you normally need to run the mysql_install_db script first, and then start the mysql daemon. Then you need to run mysqladmin to set a root password and configure the grants usually, mysqladmin -u root password 'your_root_password_for_mysql' will set the root password. You will need to restart the mysql daemon after that. On Wed, 2003-07-30 at 13:07, D. K. wrote: Petre; Running ps -aux i cannot see mysql among listed processes. I checked mysql folders under several directories , they are owned by root. Also mysql start/mysql stop etc. commands dont work producing the same warning Cant connect.. What can i do more? Thanks Devrim Petre Agenbag [EMAIL PROTECTED] schrieb am 28.07.03 08:35:48: 1) make sure mysql is running [and as user mysql] do a ps -aux to see. 2) make sure that the mysql folder and files are owned by mysql (ls -l) On Sun, 2003-07-27 at 10:38, D. K. wrote: Hi; I have installed suse 8.2 a short while ago and at my first attempt to connect mysql (via shell and a perl dbi script) i get following error: can't connect to mysql server through socjet '/var/lib/mysql/mysql.sock'. i know this looks like a common error and I am terribly sorry if this kind of subject has been posted before but I'll appreciate any urgent help. Thanks Devrim __ ComputerBild 15-03 bestaetigt: Den besten Spam-Schutz gibt es bei WEB.DE FreeMail - Deutschlands beste E-Mail - http://s.web.de/?mc=021121 __ ComputerBild (15-03) empfiehlt: Der beste Spam-Schutz ist bei WEB.DE FreeMail - Deutschlands beste E-Mail - http://s.web.de/?mc=021124 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Re: Re: cant connect to mysql server through socket
Don't stare too long at the Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) , it will blind you after a couple of minutes ;p Seriously, the fact that the sock file is not there simply tells me that mysql is not running, ie, even if you could copy a mysql.sock file to that location, your problems would still be there. the sock file is created by mysql when it starts up. You should first run the mysql_install_db script, then start mysql, then set the password. mysqladmin won't run either if mysql daemon is not running. what I suggest you do is to check that mysql is set to start in runlevels 3 to 5 in your init scripts, then reboot the machine and see if suse will have better luck in starting mysql. You can't do anything before mysql is not running. Also, check to see in your my.cnf file that all the values listed there makes sense for your system. On Wed, 2003-07-30 at 15:04, D. K. wrote: Petre; My installation is coming with suse.I ran mysql_install_db and after that i tried setting root passwd as you see below,and i got foollowing errors. I had checked mentioned socket under /var/lib/mysql -mysql.sock- before and it doesnt exist. Blame me for not reporting it before. Thank you for kind help. Devrim linux:/usr/bin # mysqladmin -u root password 'devrim' mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! __ Wo gibt es den besten Spam-Schutz? Laut ComputerBild 15-03 bei WEB.DE FreeMail - Deutschlands beste E-Mail - http://s.web.de/?mc=021122 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: cant connect to mysql server through socket
1) make sure mysql is running [and as user mysql] do a ps -aux to see. 2) make sure that the mysql folder and files are owned by mysql (ls -l) On Sun, 2003-07-27 at 10:38, D. K. wrote: Hi; I have installed suse 8.2 a short while ago and at my first attempt to connect mysql (via shell and a perl dbi script) i get following error: can't connect to mysql server through socjet '/var/lib/mysql/mysql.sock'. i know this looks like a common error and I am terribly sorry if this kind of subject has been posted before but I'll appreciate any urgent help. Thanks Devrim __ ComputerBild 15-03 bestaetigt: Den besten Spam-Schutz gibt es bei WEB.DE FreeMail - Deutschlands beste E-Mail - http://s.web.de/?mc=021121 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
cant connect to mysql server through socket
Hi; I have installed suse 8.2 a short while ago and at my first attempt to connect mysql (via shell and a perl dbi script) i get following error: can't connect to mysql server through socjet '/var/lib/mysql/mysql.sock'. i know this looks like a common error and I am terribly sorry if this kind of subject has been posted before but I'll appreciate any urgent help. Thanks Devrim __ ComputerBild 15-03 bestaetigt: Den besten Spam-Schutz gibt es bei WEB.DE FreeMail - Deutschlands beste E-Mail - http://s.web.de/?mc=021121 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: cant connect to mysql server through socket
What version of mysql are you using ? check the location of mysql.sock it probably is in /tmp/mysql/mysql.sock check the sock location in my.cnf --- D. K. [EMAIL PROTECTED] wrote: Hi; I have installed suse 8.2 a short while ago and at my first attempt to connect mysql (via shell and a perl dbi script) i get following error: can't connect to mysql server through socjet '/var/lib/mysql/mysql.sock'. i know this looks like a common error and I am terribly sorry if this kind of subject has been posted before but I'll appreciate any urgent help. Thanks Devrim __ ComputerBild 15-03 bestaetigt: Den besten Spam-Schutz gibt es bei WEB.DE FreeMail - Deutschlands beste E-Mail - http://s.web.de/?mc=021121 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo. http://search.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)
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. Unfortunately the error message conveys no useful information as to where my problem lies. I am presuming something in the configuration of the server or clients is incorrect but I have no idea of what it is. My.ini is: #This File was made using the WinMySQLAdmin 1.4 Tool #7/11/2003 9:45:28 AM #Uncomment or Add only the keys that you know how works. #Read the MySQL Manual for instructions [mysqld] basedir=C:/mysql #bind-address=24.239.132.16 datadir=C:/mysql/data #language=C:/mysql/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M [WinMySQLadmin] Server=C:/mysql/bin/mysqld.exe user=root password= In the cc I have hostname as localhost. I do note that my environment details as displayed in the admin program have details that I do not appear to be able to modify (e.g. an IP address.) If I try and match these I find the client wants to go out to the internet to access the server. What should these details be. Help!
ERROR 2003: Can't connect to MySQL server on ....
Hello list: Just finished installing mySQL on a Linux Debian system and I have a question about how the 2 root users that are set up by default. When I look at my user table there is a root user allowed to log in from localhost and also another root user but this one is only allowed to log in from host.mydomain.com (host being the computer that the mySQL server is installed in). I understand the difference since localhost is when you are working on the computer itself (or remotely through ssh) that has the mySQl server installed and that HOST.MYDOMAIN.COM is the name of the localhost machine on the LAN. However, if you are accessing the mySQL server from HOST.MYDOMAIN.COM isn't that technically the same thing as accessing from localhost? since in order to access the mySQL server from HOST.MYDOMAIN.COM I would have to be at the machine itself wouldn't the server just treat that connection as localhost? I have read on the mysql.com site about how the mySQL server sorts the entries in the user table at the time the server is started by priority of specific entries to less specific ones, however if I have a password set for both [EMAIL PROTECTED] and [EMAIL PROTECTED] then which connection would be used? Not that it matters since the set of privileges are the same. I am just really wondering if I need the extra entry of [EMAIL PROTECTED] when I already have [EMAIL PROTECTED] And how would I ever connect to the 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 to MySQL server on 'ZEUS.OLYMPUS.LOCAL' (111) I also tried using the IP of the server: Shell mysql -u root -h 192.168.1.8 -p Enter Password: *** And I still got: ERROR 2003: Can't connect to MySQL server on '192.168.1.8' (111) What does that mean? I tried searching on the list archives but found nothing on it. And I did check my /etc/hosts file and this is what is in it: 127.0.0.1 localhost 192.168.1.8 ZEUS.OLYMPUS.LOCAL ZEUS Any help would be appreciated it, thanx!
ERROR 2003: Can't connect to MySQL server on ....
Hello list: I just finished installing mySQL on a Linux Debian system and I have a question about how the 2 root users that are set up by default. When I look at my user table there is a root user allowed to log in from localhost and also another root user but this one is only allowed to log in from host.mydomain.com (host being the computer that the mySQL server is installed in). I understand the difference since localhost is when you are working on the computer itself (or remotely through ssh) that has the mySQl server installed and that HOST.MYDOMAIN.COM is the name of the localhost machine on the LAN. However, if you are accessing the mySQL server from HOST.MYDOMAIN.COM isnt that technically the same thing as accessing from localhost? since in order to access the mySQL server from HOST.MYDOMAIN.COM I would have to be at the machine itself wouldnt the server just treat that connection as localhost? I have read on the mysql.com site about how the mySQL server sorts the entries in the user table at the time the server is started by priority of specific entries to less specific ones, however if I have a password set for both [EMAIL PROTECTED] and [EMAIL PROTECTED] then which connection would be used? Not that it matters since the set of privileges are the same. I am just really wondering if I need the extra entry of [EMAIL PROTECTED] when I already have [EMAIL PROTECTED] And how would I ever connect to the 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 to MySQL server on 'ZEUS.OLYMPUS.LOCAL' (111) I also tried using the IP of the server: Shell mysql u root h 192.168.1.8 p Enter Password: *** And I still got: ERROR 2003: Can't connect to MySQL server on '192.168.1.8' (111) What does that mean? I tried searching on the list archives but found nothing on it. And I did check my /etc/hosts file and this is what is in it: 127.0.0.1 localhost 192.168.1.8 ZEUS.OLYMPUS.LOCAL ZEUS Any help would be appreciated it, thanx! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ERROR 2003: Can't connect to MySQL server on ....
Hello list: Just finished installing mySQL on a Linux Debian system and I have a question about how the 2 root users that are set up by default. When I look at my user table there is a root user allowed to log in from localhost and also another root user but this one is only allowed to log in from host.mydomain.com (host being the computer that the mySQL server is installed in). I understand the difference since localhost is when you are working on the computer itself (or remotely through ssh) that has the mySQl server installed and that HOST.MYDOMAIN.COM is the name of the localhost machine on the LAN. However, if you are accessing the mySQL server from HOST.MYDOMAIN.COM isn't that technically the same thing as accessing from localhost? since in order to access the mySQL server from HOST.MYDOMAIN.COM I would have to be at the machine itself wouldn't the server just treat that connection as localhost? I have read on the mysql.com site about how the mySQL server sorts the entries in the user table at the time the server is started by priority of specific entries to less specific ones, however if I have a password set for both [EMAIL PROTECTED] and [EMAIL PROTECTED] then which connection would be used? Not that it matters since the set of privileges are the same. I am just really wondering if I need the extra entry of [EMAIL PROTECTED] when I already have [EMAIL PROTECTED] And how would I ever connect to the 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 to MySQL server on 'ZEUS.OLYMPUS.LOCAL' (111) I also tried using the IP of the server: Shell mysql -u root -h 192.168.1.8 -p Enter Password: *** And I still got: ERROR 2003: Can't connect to MySQL server on '192.168.1.8' (111) What does that mean? I tried searching on the list archives but found nothing on it. And I did check my /etc/hosts file and this is what is in it: 127.0.0.1 localhost 192.168.1.8 ZEUS.OLYMPUS.LOCAL ZEUS Any help would be appreciated it, thanx!
Re: ERROR 2003: Can't connect to MySQL server on ....
Francisco Castellon schrieb: Hello list: Just finished installing mySQL on a Linux Debian system and I have a question about how the 2 root users that are set up by default. When I look at my user table there is a root user allowed to log in from localhost and also another root user but this one is only allowed to log in from host.mydomain.com (host being the computer that the mySQL server is installed in). I understand the difference since localhost is when you are working on the computer itself (or remotely through ssh) that has the mySQl server installed and that HOST.MYDOMAIN.COM is the name of the localhost machine on the LAN. However, if you are accessing the mySQL server from HOST.MYDOMAIN.COM isn't that technically the same thing as accessing from localhost? since in order to access the mySQL server from HOST.MYDOMAIN.COM I would have to be at the machine itself wouldn't the server just treat that connection as localhost? I have read on the mysql.com site about how the mySQL server sorts the entries in the user table at the time the server is started by priority of specific entries to less specific ones, however if I have a password set for both [EMAIL PROTECTED] and [EMAIL PROTECTED] then which connection would be used? Not that it matters since the set of privileges are the same. I am just really wondering if I need the extra entry of [EMAIL PROTECTED] when I already have [EMAIL PROTECTED] And how would I ever connect to the 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 to MySQL server on 'ZEUS.OLYMPUS.LOCAL' (111) I also tried using the IP of the server: Shell mysql -u root -h 192.168.1.8 -p Enter Password: *** And I still got: ERROR 2003: Can't connect to MySQL server on '192.168.1.8' (111) What does that mean? I tried searching on the list archives but found nothing on it. And I did check my /etc/hosts file and this is what is in it: 127.0.0.1 localhost 192.168.1.8 ZEUS.OLYMPUS.LOCAL ZEUS Any help would be appreciated it, thanx! check it with tcpdump -ilo port 3306 tcpdump -ieth0 port 3306 ... ping 192.168.1.8 telnet 192.168.1.8 3306 nmap -p3306 zeus.olympus.local ... hint $ sed s/ //g endlos.txt endloslang.txt Hellolist: JustfinishedinstallingmySQLonaLinuxDebiansystemandIhavea questionabouthowthe2rootusersthataresetupbydefault.WhenI lookatmyusertablethereisarootuserallowedtologinfrom localhostandalsoanotherrootuserbutthisoneisonlyallowedto loginfromhost.mydomain.com(hostbeingthecomputerthatthemySQL serverisinstalledin).Iunderstandthedifferencesincelocalhostis whenyouareworkingonthecomputeritself(orremotelythroughssh) thathasthemySQlserverinstalledandthatHOST.MYDOMAIN.COMisthe nameofthelocalhostmachineontheLAN.However,ifyouareaccessing themySQLserverfromHOST.MYDOMAIN.COMisn'tthattechnicallythesame thingasaccessingfromlocalhost?sinceinordertoaccessthemySQL serverfromHOST.MYDOMAIN.COMIwouldhavetobeatthemachineitself wouldn'ttheserverjusttreatthatconnectionaslocalhost?Ihaveread onthemysql.comsiteabouthowthemySQLserversortstheentriesin theusertableatthetimetheserverisstartedbypriorityofspecific entriestolessspecificones,howeverifIhaveapasswordsetforboth [EMAIL PROTECTED]@HOST.MYDOMAIN.COMthenwhichconnectionwouldbe used?Notthatitmatterssincethesetofprivilegesarethesame.Iam justreallywonderingifIneedtheextraentryof [EMAIL PROTECTED]@localhost.Andhowwould [EMAIL PROTECTED] account? AlsoIwastryingtoaccessthemySQLserverusingtheroot@ HOST.MYDOMAIN.COMaccountbyusingthecommandbelow: Shellmysql-uroot-hZEUS.OLYMPUS.LOCAL-p EnterPassword:*** AndthisiswhatIget:ERROR2003:Can'tconnecttoMySQLserveron 'ZEUS.OLYMPUS.LOCAL'(111) IalsotriedusingtheIPoftheserver: Shellmysql-uroot-h192.168.1.8-p EnterPassword:*** AndIstillgot:ERROR2003:Can'tconnecttoMySQLserveron '192.168.1.8'(111) Whatdoesthatmean?Itriedsearchingonthelistarchivesbutfound nothingonit.AndIdidcheckmy/etc/hostsfileandthisiswhatisin it: 127.0.0.1localhost 192.168.1.8ZEUS.OLYMPUS.LOCALZEUS Anyhelpwouldbeappreciatedit,thanx! /hint -- shrek-m -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: ERROR 2003: Can't connect to MySQL server on ....
Hi: Thanx for the response. But yes the ZEUS.OLYMPUS.LOCAL host is in the mysql.user database for the user root. There are 2 entries for the root user, one for [EMAIL PROTECTED] and one fore [EMAIL PROTECTED] and they both have the same global privileges set to ALL. I think that I have 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: Can't connect to MySQL server on Hi I am not an expert but I would make all root privileges global and make sure you are allowing log in's by root into any host. It just sounds like ZEUS.OLYMPUS.LOCAL is not on your allowed list. As far as my understanding goes, if you are resolving an address, then it would try to connect using the 'not' local method. Mike - Original Message - From: Francisco Castellon [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: June 5, 2003 2:40 AM Subject: ERROR 2003: Can't connect to MySQL server on Hello list: Just finished installing mySQL on a Linux Debian system and I have a question about how the 2 root users that are set up by default. When I look at my user table there is a root user allowed to log in from localhost and also another root user but this one is only allowed to log in from host.mydomain.com (host being the computer that the mySQL server is installed in). I understand the difference since localhost is when you are working on the computer itself (or remotely through ssh) that has the mySQl server installed and that HOST.MYDOMAIN.COM is the name of the localhost machine on the LAN. However, if you are accessing the mySQL server from HOST.MYDOMAIN.COM isn't that technically the same thing as accessing from localhost? since in order to access the mySQL server from HOST.MYDOMAIN.COM I would have to be at the machine itself wouldn't the server just treat that connection as localhost? I have read on the mysql.com site about how the mySQL server sorts the entries in the user table at the time the server is started by priority of specific entries to less specific ones, however if I have a password set for both [EMAIL PROTECTED] and [EMAIL PROTECTED] then which connection would be used? Not that it matters since the set of privileges are the same. I am just really wondering if I need the extra entry of [EMAIL PROTECTED] when I already have [EMAIL PROTECTED] And how would I ever connect to the 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 to MySQL server on 'ZEUS.OLYMPUS.LOCAL' (111) I also tried using the IP of the server: Shell mysql -u root -h 192.168.1.8 -p Enter Password: *** And I still got: ERROR 2003: Can't connect to MySQL server on '192.168.1.8' (111) What does that mean? I tried searching on the list archives but found nothing on it. And I did check my /etc/hosts file and this is what is in it: 127.0.0.1 localhost 192.168.1.8 ZEUS.OLYMPUS.LOCAL ZEUS Any help would be appreciated it, thanx! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 2003: Can't connect to MySQL server on ....
Hi Francisco, please login to your mysql server and do this: SHOW GRANTS FOR username; Thats probably the fastes way to troubleshoot this issue. If you really have 2 entries for the same user than t depends on 2 things which one takes precedence 1) which entry is mor specific or 2) which order they come in the mysqls privilege system. There are two reports on devshed which I believe are an excellent source. There is really nothing to add. Print them off read them carefully on your way home and tomorrrow you will be 2 steps further. http://www.devshed.com/Server_Side/MySQL/Access/page1.html http://www.devshed.com/Server_Side/MySQL/Grant_Tables/page1.html http://www.devshed.com/Server_Side/MySQL/Administration/page1.html They also offer printer friendly formats. I hope you dont think ... hmm just another document ;-). They are really worth the time. Please let me know the output of SHOW GRANTS FOR username; I am am confident to be able to help you quickly knowing the ouptut. Best regards Nils Valentin Tokyo/Japan 2003 6 6 09:41Francisco Castellon : Hi: Thanx for the response. But yes the ZEUS.OLYMPUS.LOCAL host is in the mysql.user database for the user root. There are 2 entries for the root user, one for [EMAIL PROTECTED] and one fore [EMAIL PROTECTED] and they both have the same global privileges set to ALL. I think that I have 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: Can't connect to MySQL server on Hi I am not an expert but I would make all root privileges global and make sure you are allowing log in's by root into any host. It just sounds like ZEUS.OLYMPUS.LOCAL is not on your allowed list. As far as my understanding goes, if you are resolving an address, then it would try to connect using the 'not' local method. Mike - Original Message - From: Francisco Castellon [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: June 5, 2003 2:40 AM Subject: ERROR 2003: Can't connect to MySQL server on Hello list: Just finished installing mySQL on a Linux Debian system and I have a question about how the 2 root users that are set up by default. When I look at my user table there is a root user allowed to log in from localhost and also another root user but this one is only allowed to log in from host.mydomain.com (host being the computer that the mySQL server is installed in). I understand the difference since localhost is when you are working on the computer itself (or remotely through ssh) that has the mySQl server installed and that HOST.MYDOMAIN.COM is the name of the localhost machine on the LAN. However, if you are accessing the mySQL server from HOST.MYDOMAIN.COM isn't that technically the same thing as accessing from localhost? since in order to access the mySQL server from HOST.MYDOMAIN.COM I would have to be at the machine itself wouldn't the server just treat that connection as localhost? I have read on the mysql.com site about how the mySQL server sorts the entries in the user table at the time the server is started by priority of specific entries to less specific ones, however if I have a password set for both [EMAIL PROTECTED] and [EMAIL PROTECTED] then which connection would be used? Not that it matters since the set of privileges are the same. I am just really wondering if I need the extra entry of [EMAIL PROTECTED] when I already have [EMAIL PROTECTED] And how would I ever connect to the 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 to MySQL server on 'ZEUS.OLYMPUS.LOCAL' (111) I also tried using the IP of the server: Shell mysql -u root -h 192.168.1.8 -p Enter Password: *** And I still got: ERROR 2003: Can't connect to MySQL server on '192.168.1.8' (111) What does that mean? I tried searching on the list archives but found nothing on it. And I did check my /etc/hosts file and this is what is in it: 127.0.0.1 localhost 192.168.1.8 ZEUS.OLYMPUS.LOCAL ZEUS Any help would be appreciated it, thanx! -- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
cannot connect to mysql server
I have installed mysql on Mac OS X. when I attempt to access it either through a php page or through Terminal, I receive this message; Can't connect to local MySQL server through socket '/tmp/mysql.sock' I have just switched to a Mac and am unfamiliar with many aspects of unix. I read something about creating a symbolic link but am unsure how to do this and if this will solve the problem. Any help would be greatly appreciated. Peter [EMAIL PROTECTED]
Re: cannot connect to mysql server
At 12:00 -0500 4/5/03, Peter Gumbrell wrote: I have installed mysql on Mac OS X. when I attempt to access it either through a php page or through Terminal, I receive this message; Can't connect to local MySQL server through socket '/tmp/mysql.sock' mysqld isn't running. You can check to see if it is running with (run this in a terminal window): cd /usr/local/mysql ./bin/mysqlamdin ping to start mysqld use: shell bin/safe_mysqld --user=mysql or shell bin/mysqld_safe --user=mysql if you are running MySQL 4.x --user=msyql should be the user that you set up to own the msql directories. I have just switched to a Mac and am unfamiliar with many aspects of unix. I read something about creating a symbolic link but am unsure how to do this and if this will solve the problem. Any help would be greatly appreciated. Peter [EMAIL PROTECTED] -- Jeff Shapiro, Colorado Springs, CO, USA At work I *have* to use a Windows machine, at home I *get* to use a Mac. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: cannot connect to mysql server
Try the following cd /usr/local/mysql ./bin/mysqld_safe and see if that starts up the server. If it doesn't, check to make sure you don't have a proxy set in your internet configurations. Todd On Saturday, April 5, 2003, at 12:00 PM, Peter Gumbrell wrote: I have installed mysql on Mac OS X. when I attempt to access it either through a php page or through Terminal, I receive this message; Can't connect to local MySQL server through socket '/tmp/mysql.sock' I have just switched to a Mac and am unfamiliar with many aspects of unix. I read something about creating a symbolic link but am unsure how to do this and if this will solve the problem. Any help would be greatly appreciated. Peter [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cant connect to Mysql server on 'localhost' (10061)
Hi, have you setup a my.ini File? mine looks like: [mysqld] basedir=f:/mysql datadir=f:/mysql/data language=f:/mysql/share/german Bernhard - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 31, 2003 4:11 AM Subject: Cant connect to Mysql server on 'localhost' (10061) Does anyone else get this message after installing and attempting to run mysql (version 4.0.12)?? I downloaded and installed mysql-4.0.12-win.zip file. then from the command prompt, I typed mysqld to start the service. Then I typed mysql and I got the error message: Cant connect to Mysql server on 'localhost' (10061) Am I doing something wrong ?? I checked and confirmed that mysql is running as a service on my PC, but I noted when using the winmysqladmin tool that no mysql server was being specified - probably the cuase of the problem, but how do I fix it. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cant connect to Mysql server on 'localhost' (10061)
check this first in command prompt mysqladmin ping. You should receive Mysql is alive. Otherwise you have to start your service. From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Subject: Cant connect to Mysql server on 'localhost' (10061) Date: Mon, 31 Mar 2003 12:11:32 +1000 Does anyone else get this message after installing and attempting to run mysql (version 4.0.12)?? I downloaded and installed mysql-4.0.12-win.zip file. then from the command prompt, I typed mysqld to start the service. Then I typed mysql and I got the error message: Cant connect to Mysql server on 'localhost' (10061) Am I doing something wrong ?? I checked and confirmed that mysql is running as a service on my PC, but I noted when using the winmysqladmin tool that no mysql server was being specified - probably the cuase of the problem, but how do I fix it. THanks to anyone that can help. Michael Hall Snr Web Developer Insurance Council of Australia Email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Cant connect to Mysql server on 'localhost' (10061)
Does anyone else get this message after installing and attempting to run mysql (version 4.0.12)?? I downloaded and installed mysql-4.0.12-win.zip file. then from the command prompt, I typed mysqld to start the service. Then I typed mysql and I got the error message: Cant connect to Mysql server on 'localhost' (10061) Am I doing something wrong ?? I checked and confirmed that mysql is running as a service on my PC, but I noted when using the winmysqladmin tool that no mysql server was being specified - probably the cuase of the problem, but how do I fix it. THanks to anyone that can help. Michael Hall Snr Web Developer Insurance Council of Australia Email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Cannot connect to mysql server
Hello, I have an interesting problem. I installed mysql client and server from Redhat 7.3 RPM. Then I set up a username and password for a user monty (to use example from the manual). Then I grant priveleges for the user with: mysql GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED] - IDENTIFIED BY 'some_pass' WITH GRANT OPTION; mysql GRANT ALL PRIVILEGES ON *.* TO monty@% - IDENTIFIED BY 'some_pass' WITH GRANT OPTION; and restarted mysql server. Let's assume the server name is sql.domain.edu I then tried to connect to the server as user monty from localhost: $ mysql -u monty -p and then tried it from another machine console: $ mysql -u monty -h sql.domain.edu -p and all is well. But when i tried to connect using the console from localhost (ie. sql.domain.edu) by specifiying hostname: $ mysql -u monty -h sql.domain.edu -p I got the cannot connect user [EMAIL PROTECTED] error message. Why does this happen? I fixed this by doing mysql GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED] - IDENTIFIED BY 'some_pass' WITH GRANT OPTION; but I thought I already specified the wildcard on my previous grant previlege so that monty can access from *any* machine. Just curious as t why this happens, can anyone help? Thanks a lot. Reuben D. Budiardja -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
connect to mysql server
how do i create a user that can connect to any database from any host on my lan :-) Sidar Lopez Cruz - Cero Riesgo, S.A.
Re: connect to mysql server
Sidar, how do i create a user that can connect to any database from any host on my lan mysql GRANT ALL ON *.* TO 'youruser'@'192.168.%' IDENTIFIED BY 'secret'; Assuming your network has IP addresses starting with 192.168. Regards, -- Stefan Hinz [EMAIL PROTECTED] iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
FW: Connect to mysql server fail!
hi,experts: I installed mysql (3.23.56, server client) at my NT4.0 machine. As I unziped and set up mysql, everything seemed fine ( I used winmysqladmin to start mysqld-nt server). That mean that the mysql server is running. However, when I create 'root' with mysqladmin command as follows: --g:\mysql\bin\mysqladmin -u root password 'therootpassword' and then try to see the status og mysql using following command: --g:\mysql\bin\mysqladmin -u root -p status Enter Password: I got the error message: mysqladmin: coonect to server at 'localhost' failed error: 'Access denied for user:[EMAIL PROTECTED]' ,Using password: Yes' Are there any mis-configuration in my installing process. Can anyone show me how to fix this problem? Thanks. Chien-Lung - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FW: Connect to mysql server fail!
hi,experts: I installed mysql (3.23.49, server client) at my NT4.0 machine. As I unziped and set up mysql, everything seemed fine ( I used winmysqladmin to start mysqld-nt server). That mean that the mysql server is running. However, when I create 'root' with mysqladmin command as follows: --g:\mysql\bin\mysqladmin -u root password 'therootpassword' and then try to see the status og mysql using following command: --g:\mysql\bin\mysqladmin -u root -p status Enter Password: I got the error message: mysqladmin: coonect to server at 'localhost' failed error: 'Access denied for user:[EMAIL PROTECTED]' ,Using password: Yes' Are there any mis-configuration in my installing process. Can anyone show me how to fix this problem? Thanks. Chien-Lung - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: FW: Connect to mysql server fail!
You did not create 'root'. You set the root password to 'therootpassword' Did you enter the same password you set? Enter Password : therootpassword Chien-Lung Wu wrote: hi,experts: I installed mysql (3.23.49, server client) at my NT4.0 machine. As I unziped and set up mysql, everything seemed fine ( I used winmysqladmin to start mysqld-nt server). That mean that the mysql server is running. However, when I create 'root' with mysqladmin command as follows: --g:\mysql\bin\mysqladmin -u root password 'therootpassword' and then try to see the status og mysql using following command: --g:\mysql\bin\mysqladmin -u root -p status Enter Password: I got the error message: mysqladmin: coonect to server at 'localhost' failed error: 'Access denied for user:[EMAIL PROTECTED]' ,Using password: Yes' Are there any mis-configuration in my installing process. Can anyone show me how to fix this problem? Thanks. Chien-Lung - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php