September 14th, 2000, 03:52 AM
-
I get the following error when I trie to connect to mysql with mysqlgui.exe
Warning: MySQL Connection Failed: Can't Connect to MySQL server on 'localhost' (10061)
But mysql server is running (using mysqld.exe) on my win98 machine (The green light of WinMysqlAdmin is) and I can ping localhost.
Can anyone help me with this. My my.ini is pasted below.
Chris
my.ini:
#This File was made using the Winmysqladmin 1.0 Tool
#14-08-2000 10:25:40
#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions
[mysqld]
basedir=c:apachemysql
bind-address=192.168.0.2
datadir=c:apachemysqldata
#language=c:Program Filesmysqlsharedutch
delay-key-write-for-all-tables
log-long-format
ansi
new
port=3307
safe
skip-name-resolve
skip-networking
skip-new
skip-host-cache
set-variable=key_buffer=16M
set-variable=max_allowed_packet=1M
set-variable=thread_stack=128K
set-variable=flush_time=1800
[mysqldump]
quick
set-variable=max_allowed_packet=16M
[mysql]
no-auto-rehash
[isamchk]
set-variable=key=16M
[Winmysqladmin]
Server=c:/apache/mysql/bin/mysqld-opt.exe
user=root
password=test
September 14th, 2000, 08:41 AM
-
Create a file C:my.cnf with the following contents ONLY (yes, slashes are pointed the right way):
[mysqld]
basedir=C:/apache/mysql/
MySQL looks for itself in the default directory of C:mysql on Win32.
September 14th, 2000, 04:09 PM
-
I connect with the internet trough a gateway. In my tcp/ip settings of my networkcard (connected with the ethernet), I had my DNS enabled. After disableing my DNS, everything worked.
September 14th, 2000, 06:36 PM
-
sounds like localhost was resolving to 127.0.0.1 but you've specified 192.168.0.2
c:windowsHosts.sam editied and renamed to Hosts would prolly sort that
Bealers
------------------
http://back-end.org
September 15th, 2000, 04:38 AM
-