Re: [Replication] Problem connecting to master

2005-08-31 Thread Jan Roehrich
> If nothing helps, trace files could spill the light on your problem. many thanks for your help. With tracing I found the problem. Like almost every time it was just a typing error :-( Regards Jan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: [Replication] Problem connecting to master

2005-08-30 Thread Gleb Paharenko
Hello. If nothing helps, trace files could spill the light on your problem. See: http://dev.mysql.com/doc/mysql/en/making-trace-files.html Jan Roehrich <[EMAIL PROTECTED]> wrote: >> --skip-networking can be specified as the command line option. Use: >> show variables like 'skip_ne

Re: [Replication] Problem connecting to master

2005-08-29 Thread Nuno Pereira
Jan Roehrich wrote: --skip-networking can be specified as the command line option. Use: show variables like 'skip_networking'; to check if it is enabled. mysql> show variables like 'skip_networking'; +-+---+ | Variable_name | Value | +-+---+ | skip_ne

Re: [Replication] Problem connecting to master

2005-08-29 Thread Jan Roehrich
> --skip-networking can be specified as the command line option. Use: > show variables like 'skip_networking'; > to check if it is enabled. mysql> show variables like 'skip_networking'; +-+---+ | Variable_name | Value | +-+---+ | skip_networking | OFF

Re: [Replication] Problem connecting to master

2005-08-29 Thread Gleb Paharenko
Hello. > Could not see skip-networking anywhere. --skip-networking can be specified as the command line option. Use: show variables like 'skip_networking'; to check if it is enabled. Jan Roehrich <[EMAIL PROTECTED]> wrote: >> Please send your configuration files for master and s

Re: [Replication] Problem connecting to master

2005-08-29 Thread Jan Roehrich
> Please send your configuration files for master and slave. Check that > > you don't have skip-networking in your slave's configuration file. Master: -- [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock log-bin=bin-log server-id=1 [mysql.server] user=m

Re: [Replication] Problem connecting to master

2005-08-29 Thread Gleb Paharenko
Hello. Please send your configuration files for master and slave. Check that you don't have skip-networking in your slave's configuration file. Jan Roehrich <[EMAIL PROTECTED]> wrote: > I have a strange problem setting up replication. I followed each step of > setting up replication in t

[Replication] Problem connecting to master

2005-08-28 Thread Jan Roehrich
I have a strange problem setting up replication. I followed each step of setting up replication in the mysqld documentation (http://dev.mysql.com/doc/mysql/en/replication-howto.html). But there are some error messages on the salve: 050828 13:22:58 [ERROR] Slave I/O thread: error connecting to mas

Problem connecting to MySQL 4.0.23 with MySQL Administrator 1.0.21 (Mac OS X)

2005-06-14 Thread Jan Pieter Kunst
Dear all, I have a MySQL 4.0.23 server running on an OpenBSD machine. When I try to connect to it with MySQL Administrator 1.0.21 from my Mac OS X machine, I get this error: Connection error Could not connect to MySQL instance at . Error: unknown system variable 'sql_mode' (code 1193) I can conn

Re: Problem connecting to 4.1 server

2005-05-23 Thread Gleb Paharenko
Hello. You may compile MySQL from source by yourself with enabled debugging, if an official binaries don't include it. See: http://dev.mysql.com/doc/mysql/en/windows-source-build.html I suggest you to forward your message to win32 list: http://lists.mysql.com/win32 Nicholas

Re: Problem connecting to 4.1 server

2005-05-22 Thread Nicholas Watmough
Hi, I read the suggested section, but I'm not sure whether I can actually do any debugging with the pre-compiled Windows MySQL server. Is it possible to turn on debugging with the pre-compiled binaries on Windows? I'm also not sure what the difference is between libmysql.lib and mysqlclient.

Re: Problem connecting to 4.1 server

2005-05-19 Thread Gleb Paharenko
Hello. You may switch to the debug version of libmysqlclient and research the problem. See: http://dev.mysql.com/doc/mysql/en/debugging-client.html > Yes, the mysql.exe is the same version - I installed version 4.1.10 of > the server (and binaries) from the Windows executab

Re: Problem connecting to 4.1 server

2005-05-16 Thread Nicholas Watmough
Yes, the mysql.exe is the same version - I installed version 4.1.10 of the server (and binaries) from the Windows executable myself, about two months ago. I've tried setting MYSQL_SECURE_AUTH to both true and false, to see if it solves the problem, but it doesn't. Not sure what else I can try.

Re: Problem connecting to 4.1 server

2005-05-06 Thread Gleb Paharenko
Hello. Are you sure that mysql.exe is the same version as the server? Check if you're able to connect to 3.23.xx server using API. What value does your MYSQL_SECURE_AUTH option have? See: http://dev.mysql.com/doc/mysql/en/mysql-options.html Nicholas Watmough <[EMAIL PROTECTED]> w

Problem connecting to 4.1 server

2005-05-04 Thread Nicholas Watmough
I am have trouble connecting to the MySQL server 4.1 using the API, though I have no trouble connecting using the same parameters from the command line mysql.exe. I'm using server version 4.1.10 on Windows Server 2003, which was started with --old-password (to ensure back compatibility with leg

Re: Problem connecting to MySQL 4.1.7 running on another machine

2004-11-15 Thread Adam
Kevin, Could be a few things causing problems. Lets look at the most obvious. First, make sure you can login locally as root. Second, MySQL authenticates based on user, password, and host. If you have a know user with the right password coming from an unknown host MySQL will bounce you. http://

Re: Problem connecting to MySQL 4.1.7 running on another machine

2004-11-15 Thread Richard Whitney
Quoting Kevin Barry <[EMAIL PROTECTED]>: > I've installed ver 4.1.7 on a brand new Fedora Core 3 server but cannot > connect remotely from a Mac OSX machine running Navicat or a Win XP machine > running MySQL Admin. I can ping the machine with no problem and have opened > the firewall for the 3306

Problem connecting to MySQL 4.1.7 running on another machine

2004-11-15 Thread Kevin Barry
I've installed ver 4.1.7 on a brand new Fedora Core 3 server but cannot connect remotely from a Mac OSX machine running Navicat or a Win XP machine running MySQL Admin. I can ping the machine with no problem and have opened the firewall for the 3306 port. The error I receive is: Could not connect

Re: Problem connecting to MySQL server

2004-11-09 Thread Gleb Paharenko
Hello. See: http://dev.mysql.com/doc/mysql/en/Can_not_connect_to_server.html Schalk Neethling <[EMAIL PROTECTED]> wrote: > Hey there > > I have upgraded the MySQL server on my Windows machine to 4.0.22 > following the docs at: > http://dev.mysql.com/doc/mysql/en/Windows_upgrading

Problem connecting to MySQL server

2004-11-08 Thread Schalk Neethling
Hey there I have upgraded the MySQL server on my Windows machine to 4.0.22 following the docs at: http://dev.mysql.com/doc/mysql/en/Windows_upgrading.html When I start the server using NET START MySQL the server starts with no problems and the following is written to my error log: 041108 14:24

problem connecting with PHP

2004-02-09 Thread Nikola Skoric
Hello, I've recently upgraded from 3.23 to 4.0.16. Before upgrading my PHP scripts connecting to mysql server from another machine (not from localhost) were doing just fine. But, since upgrading, I get tihs warnings: Warning: Lost connection to MySQL server during query in /home/users2/nick/publ

Problem Connecting To Mysql Server

2003-09-04 Thread naoufal
Hi there ##ERROR 2013: Lost connection to MySQL server during query ## I get this error when i try to remotely connect to my mysql server, it has been working until i changed the server's ip and isp, when i re-change the mysql server to the old ip address (first isp), it's working again . When i do

Problem Connecting To mysql server

2003-09-04 Thread naoufal
Hi there ##ERROR 2013: Lost connection to MySQL server during query ## i get this error when i try to remotely connect to my mysql server, it has been working until i changed the server's ip and isp, when i re-change the mysql server to the old ip address (first isp), it's working again . when i

Re: Problem connecting with sockets to MySQL

2003-05-29 Thread Jose Miguel Pérez
Hi Nils! First of all, thanks for your reply. > I believe you miss an important point. Error 1130 means that the host (ip > address) is not allowed to connect, it doesnt mean that its not physically > possible. You have to check the privileges you gave the user or host that > doesnt work.

Re: Problem connecting with sockets to MySQL

2003-05-29 Thread Nils Valentin
Hi Jose, I believe you miss an important point. Error 1130 means that the host (ip address) is not allowed to connect, it doesnt mean that its not physically possible. You have to check the privileges you gave the user or host that doesnt work. login to mysql from a working account. do this:

Problem connecting with sockets to MySQL

2003-05-29 Thread Jose Miguel Pérez
Hi all! I have asked this before, but no replys. I'll rewrite the question because I don't know if I got understood. ;-) Anyway, I have not found a MySQL list best suited for this question, so here I go... ¿Anyone knows why the server (mysqld) behaves differently to clients connecting fro

Re: problem connecting to mysqld

2003-02-28 Thread Prabu Subroto
Of course because your MySQL engine is off. Start up your MySQL. Why not with Linux. Linux is far better than the Stupid Windows Plat form. Windows is only for a computer idiot. (but I am not meaning that you are idiot. I mean the windows). --- Ahmed Shams <[EMAIL PROTECTED]> wrote: > > I am ha

RE: problem connecting to mysqld

2003-02-27 Thread Jun.Han
) " -Original Message- From: miguel solorzano [mailto:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 7:09 AM To: Ahmed Shams; [EMAIL PROTECTED] Subject: Re: problem connecting to mysqld At 22:05 27/02/2003 +, Ahmed Shams wrote: >I am having problems using MYSQL on Windows ME op

Re: problem connecting to mysqld

2003-02-27 Thread miguel solórzano
At 22:05 27/02/2003 +, Ahmed Shams wrote: I am having problems using MYSQL on Windows ME operating system. It installs fine with no problems, but at the point where I try to connect to mysqld i get the error of bad command or file name at the dos propmt. therefore when I try to create a dat

problem connecting to mysqld

2003-02-27 Thread Ahmed Shams
I am having problems using MYSQL on Windows ME operating system. It installs fine with no problems, but at the point where I try to connect to mysqld i get the error of bad command or file name at the dos propmt. therefore when I try to create a database I keep getting "Error-2003: Can't connect

problem connecting to mysql using myodbc 3.51.05

2003-02-10 Thread Wong, Sherman
> >Hi, > >I am currently running mysql-3.23.52-3 on Linux 8.0 and myodbc 3.51.05 on win2000 >machines respectively. >Users and host IP has been setup on mysql, and innodb has been setup with as below. > >innodb_data_file_path = ibdata1:10M:autoextend >set-variable = innodb_buffer_pool_size=70M >

Problem connecting to DB

2003-01-26 Thread Beogradjanin
Zdravo mysql, Hi I have problem connectong to DB MySQL Attempting to attach to database... The database has failed to connect because you do not have permission to connect to the server. Please go back to the last step and ensure that you have entered all your login details correctly. I did a

Re: problem connecting to mysql with gui

2002-08-16 Thread Egor Egorov
samuel, Friday, August 16, 2002, 12:45:36 AM, you wrote: su> please how can i set Sql command on connect to be able to connect to su> mysql.i am a novice.i tried to enter /var/lib/mysql/mysql.sock but still su> couldn't connect.help please. i have tried with both static and su> semi-static fil

problem connecting to mysql with gui

2002-08-15 Thread samuel umoette
please how can i set Sql command on connect to be able to connect to mysql.i am a novice.i tried to enter /var/lib/mysql/mysql.sock but still couldn't connect.help please. i have tried with both static and semi-static files. thanks.

Re: Socket problem connecting

2002-05-19 Thread Samuel Mendelowski
problem with permission; change rights to group and user mysql to mysql data directory Todd Cary > I am getting this message when I try to establish a connect to the DB. > Any suggestions on where I can find an answer? > > Warning: Can't connect to local MySQL server through socket > '/tmp/mys

Re: Re: Socket problem connecting

2002-05-17 Thread Egor Egorov
Todd, Friday, May 17, 2002, 4:36:37 PM, you wrote: TC> Egor - TC> Question 1: TC> I located where mysql.sock is located - /var/lib/mysql/mysql.sock - NOT /tmp. TC> However, it is a symbolic link. TC> Shouldn't there be an actual file in addition to the symbolic link? TC> Linux is very new to me

Re: Socket problem connecting

2002-05-17 Thread Todd Cary
Egor - Question 1: I located where mysql.sock is located - /var/lib/mysql/mysql.sock - NOT /tmp. However, it is a symbolic link. Shouldn't there be an actual file in addition to the symbolic link? Linux is very new to me, so I am not up to speed on many of the intricacies. Question 2: There

Re: Socket problem connecting

2002-05-17 Thread Egor Egorov
Todd, Friday, May 17, 2002, 6:03:06 AM, you wrote: TC> I am getting this message when I try to establish a connect to the DB. Any TC> suggestions on where I can find an answer? TC> Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' TC> (2) in /var/www/html/mysql/php/c

Socket problem connecting

2002-05-16 Thread Todd Cary
I am getting this message when I try to establish a connect to the DB. Any suggestions on where I can find an answer? Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /var/www/html/mysql/php/connect.php on line 2 Todd -- Todd Cary Ariste Software 2200 D Stre

RE: [PHP] Problem connecting to mysql via odbc

2001-11-30 Thread Andrew Hill
Access & Data Integration Technology Providers > -Original Message- > From: mweb [mailto:[EMAIL PROTECTED]] > Sent: Friday, November 30, 2001 12:02 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: [PHP] Problem connecting to mysql via odbc > > > Hello,

Problem connecting to mysql via odbc

2001-11-29 Thread mweb
Hello, I have a page whoch should connect to a mysql database via odbc, on a RH 7.2 PC with the relevant rpm listed below. I know what to do when the db is reachable, but can't start: the instruction: $conn=odbc_connect("db9,"",""); just yelds this result: Warning: SQL error: [unixODBC][Driver M

Problem connecting to db after installation on linux 7.1

2001-07-23 Thread MySQL server
Description: I've installed mysql on my linux 7.1 server (via RPMS) and it self-configured. It is now running however I can not connect to it. I keep getting the followingn error message: mysqladmin: connect to server 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using pas

problem connecting

2001-01-18 Thread Alexandru Mincu
I installed mysql on a Suse 6.4 and it's works, but with only one problem when I tried connecting from another computer with a php file it says Warning : MySQL connection failed : host ' ... ' is not allowed to connect to this MySQL server on ' ... ' line X If someone could help me please send