473,287 Members | 1,674 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

Cant't connect

Hi, I have a problem to connect to my local server

After I have done:

c:\mysql\bin>mysqld --standalone

I try:

C:\mysql\bin>mysql
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

Whats the problem, and where can I get help.

mvh
Curt
Jul 19 '05 #1
13 7684
Curt Larsson wrote:
Hi, I have a problem to connect to my local server

After I have done:

c:\mysql\bin>mysqld --standalone


Is the server running? Do you see it in the process list?
Jul 19 '05 #2
No.
Maybe something can be wrong in my.cnf 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]
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 = d:/mysql/
#datadir = d:/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
"Aggro" <sp**********@yahoo.com> skrev i meddelandet
news:tP************@read3.inet.fi...
Curt Larsson wrote:
Hi, I have a problem to connect to my local server

After I have done:

c:\mysql\bin>mysqld --standalone


Is the server running? Do you see it in the process list?

Jul 19 '05 #3
Curt Larsson wrote:
No.
Maybe something can be wrong in my.cnf file.


Have you changed it or is it original?

What exactly happens after you have done:

c:\mysql\bin>mysqld --standalone

Does it print any messages? Is there anything at the error.log?
Jul 19 '05 #4
Aggro wrote:
Have you changed it or is it original? It's original.
What exactly happens after you have done:

c:\mysql\bin>mysqld --standalone

Does it print any messages? Is there anything at the error.log?

No message is shown.
This is in my log:

040404 11:00:26 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 43892
InnoDB: Doing recovery: scanned up to log sequence number 0 43892
InnoDB: Page directory corruption: supremum not pointed to
040404 11:00:26 InnoDB: Page dump in ascii and hex (16384 bytes):
len 16384; hex 000000000000000000

A lot of 0's

InnoDB: End of page dump
040404 11:00:26 InnoDB: Page checksum 1575996416, prior-to-4.0.14-form
checksum 1371122432
InnoDB: stored checksum 0, prior-to-4.0.14-form stored checksum 0
InnoDB: Page lsn 0 0, low 4 bytes of lsn at page end 0
InnoDB: Page directory corruption: supremum not pointed to
040404 11:00:26 InnoDB: Page dump in ascii and hex (16384 bytes):
len 16384; hex 00000000000

More of 0's

InnoDB: End of page dump
040404 11:00:26 InnoDB: Page checksum 1575996416, prior-to-4.0.14-form
checksum 1371122432
InnoDB: stored checksum 0, prior-to-4.0.14-form stored checksum 0
InnoDB: Page lsn 0 0, low 4 bytes of lsn at page end 0
040404 11:00:26 mysqld: Got signal 11. Aborting!

040404 11:00:26 Aborting

040404 11:00:26 InnoDB: Warning: shutting down a not properly started
InnoDB: or created database!
040404 11:00:26 mysqld: Shutdown Complete

thanks
Curt
Jul 19 '05 #5
Aggro wrote:
Have you changed it or is it original? It's original.
What exactly happens after you have done:

c:\mysql\bin>mysqld --standalone

Does it print any messages? Is there anything at the error.log?

No message is shown.
This is in my log:

040404 11:00:26 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 43892
InnoDB: Doing recovery: scanned up to log sequence number 0 43892
InnoDB: Page directory corruption: supremum not pointed to
040404 11:00:26 InnoDB: Page dump in ascii and hex (16384 bytes):
len 16384; hex 000000000000000000

A lot of 0's

InnoDB: End of page dump
040404 11:00:26 InnoDB: Page checksum 1575996416, prior-to-4.0.14-form
checksum 1371122432
InnoDB: stored checksum 0, prior-to-4.0.14-form stored checksum 0
InnoDB: Page lsn 0 0, low 4 bytes of lsn at page end 0
InnoDB: Page directory corruption: supremum not pointed to
040404 11:00:26 InnoDB: Page dump in ascii and hex (16384 bytes):
len 16384; hex 00000000000

More of 0's

InnoDB: End of page dump
040404 11:00:26 InnoDB: Page checksum 1575996416, prior-to-4.0.14-form
checksum 1371122432
InnoDB: stored checksum 0, prior-to-4.0.14-form stored checksum 0
InnoDB: Page lsn 0 0, low 4 bytes of lsn at page end 0
040404 11:00:26 mysqld: Got signal 11. Aborting!

040404 11:00:26 Aborting

040404 11:00:26 InnoDB: Warning: shutting down a not properly started
InnoDB: or created database!
040404 11:00:26 mysqld: Shutdown Complete

thanks
Curt
Jul 19 '05 #6
Curt Larsson wrote:
InnoDB: Page directory corruption: supremum not pointed to
040404 11:00:26 InnoDB: Page dump in ascii and hex (16384 bytes):
len 16384; hex 000000000000000000


I don't know what is going on, but unless there is anything important in
your database, I would suggest you to uninstall it, and try to reinstall it.

If this doesn't help, you could try to see if there is anything wrong
with your hardware. i.e. run hard drive tests and memory test, to make
sure that they are okay.

If hardware seems to be okay, and reinstall doesn't help, you could also
try to install older version of MySQL to see if that works any better.

If that also fails, see if there is anything you are doing incorrectly
in the installation process, by following installation manual.

All this is just wild guesses, I really don't have a clue what could be
causing this.
Jul 19 '05 #7
Curt Larsson wrote:
InnoDB: Page directory corruption: supremum not pointed to
040404 11:00:26 InnoDB: Page dump in ascii and hex (16384 bytes):
len 16384; hex 000000000000000000


I don't know what is going on, but unless there is anything important in
your database, I would suggest you to uninstall it, and try to reinstall it.

If this doesn't help, you could try to see if there is anything wrong
with your hardware. i.e. run hard drive tests and memory test, to make
sure that they are okay.

If hardware seems to be okay, and reinstall doesn't help, you could also
try to install older version of MySQL to see if that works any better.

If that also fails, see if there is anything you are doing incorrectly
in the installation process, by following installation manual.

All this is just wild guesses, I really don't have a clue what could be
causing this.
Jul 19 '05 #8
Aggro wrote:
Have you changed it or is it original? It's original.
What exactly happens after you have done:

c:\mysql\bin>mysqld --standalone

Does it print any messages? Is there anything at the error.log?

No message is shown.
This is in my log:

040404 11:00:26 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 43892
InnoDB: Doing recovery: scanned up to log sequence number 0 43892
InnoDB: Page directory corruption: supremum not pointed to
040404 11:00:26 InnoDB: Page dump in ascii and hex (16384 bytes):
len 16384; hex 000000000000000000

A lot of 0's

InnoDB: End of page dump
040404 11:00:26 InnoDB: Page checksum 1575996416, prior-to-4.0.14-form
checksum 1371122432
InnoDB: stored checksum 0, prior-to-4.0.14-form stored checksum 0
InnoDB: Page lsn 0 0, low 4 bytes of lsn at page end 0
InnoDB: Page directory corruption: supremum not pointed to
040404 11:00:26 InnoDB: Page dump in ascii and hex (16384 bytes):
len 16384; hex 00000000000

More of 0's

InnoDB: End of page dump
040404 11:00:26 InnoDB: Page checksum 1575996416, prior-to-4.0.14-form
checksum 1371122432
InnoDB: stored checksum 0, prior-to-4.0.14-form stored checksum 0
InnoDB: Page lsn 0 0, low 4 bytes of lsn at page end 0
040404 11:00:26 mysqld: Got signal 11. Aborting!

040404 11:00:26 Aborting

040404 11:00:26 InnoDB: Warning: shutting down a not properly started
InnoDB: or created database!
040404 11:00:26 mysqld: Shutdown Complete

thanks
Curt
Jul 19 '05 #9
Curt Larsson wrote:
InnoDB: Page directory corruption: supremum not pointed to
040404 11:00:26 InnoDB: Page dump in ascii and hex (16384 bytes):
len 16384; hex 000000000000000000


I don't know what is going on, but unless there is anything important in
your database, I would suggest you to uninstall it, and try to reinstall it.

If this doesn't help, you could try to see if there is anything wrong
with your hardware. i.e. run hard drive tests and memory test, to make
sure that they are okay.

If hardware seems to be okay, and reinstall doesn't help, you could also
try to install older version of MySQL to see if that works any better.

If that also fails, see if there is anything you are doing incorrectly
in the installation process, by following installation manual.

All this is just wild guesses, I really don't have a clue what could be
causing this.
Jul 19 '05 #10
Curt,

"Curt Larsson" <ku***@chello.se> kirjoitti viestissä
news:pfQbc.7377$EV2.65395@amstwist00...
Aggro wrote:
Have you changed it or is it original? It's original.
What exactly happens after you have done:

c:\mysql\bin>mysqld --standalone

Does it print any messages? Is there anything at the error.log?

No message is shown.
This is in my log:

040404 11:00:26 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 43892
InnoDB: Doing recovery: scanned up to log sequence number 0 43892
InnoDB: Page directory corruption: supremum not pointed to
040404 11:00:26 InnoDB: Page dump in ascii and hex (16384 bytes):
len 16384; hex 000000000000000000

A lot of 0's


when you installed MySQL, something went wrong and InnoDB's tablespace was
not created properly.

Read
http://www.innodb.com/ibman.php#Wrong.creation
and retry installation.
thanks
Curt


Best regards,

Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php

Register now for the 2004 MySQL Users Conference!
http://www.mysql.com/events/uc2004/index.html
Jul 19 '05 #11
Curt,

"Curt Larsson" <ku***@chello.se> kirjoitti viestissä
news:pfQbc.7377$EV2.65395@amstwist00...
Aggro wrote:
Have you changed it or is it original? It's original.
What exactly happens after you have done:

c:\mysql\bin>mysqld --standalone

Does it print any messages? Is there anything at the error.log?

No message is shown.
This is in my log:

040404 11:00:26 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 43892
InnoDB: Doing recovery: scanned up to log sequence number 0 43892
InnoDB: Page directory corruption: supremum not pointed to
040404 11:00:26 InnoDB: Page dump in ascii and hex (16384 bytes):
len 16384; hex 000000000000000000

A lot of 0's


when you installed MySQL, something went wrong and InnoDB's tablespace was
not created properly.

Read
http://www.innodb.com/ibman.php#Wrong.creation
and retry installation.
thanks
Curt


Best regards,

Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php

Register now for the 2004 MySQL Users Conference!
http://www.mysql.com/events/uc2004/index.html
Jul 19 '05 #12
Curt,

"Curt Larsson" <ku***@chello.se> kirjoitti viestissä
news:pfQbc.7377$EV2.65395@amstwist00...
Aggro wrote:
Have you changed it or is it original? It's original.
What exactly happens after you have done:

c:\mysql\bin>mysqld --standalone

Does it print any messages? Is there anything at the error.log?

No message is shown.
This is in my log:

040404 11:00:26 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 43892
InnoDB: Doing recovery: scanned up to log sequence number 0 43892
InnoDB: Page directory corruption: supremum not pointed to
040404 11:00:26 InnoDB: Page dump in ascii and hex (16384 bytes):
len 16384; hex 000000000000000000

A lot of 0's


when you installed MySQL, something went wrong and InnoDB's tablespace was
not created properly.

Read
http://www.innodb.com/ibman.php#Wrong.creation
and retry installation.
thanks
Curt


Best regards,

Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php

Register now for the 2004 MySQL Users Conference!
http://www.mysql.com/events/uc2004/index.html
Jul 19 '05 #13
I just installed MySQL and I got and fixed a similar problem. As previous posters mentioned it's some wacked detail about your InnoDB table.

What resolved my problem was changing the location of the InnoDB table thus it is created anew. I was able to do this using the configurator GUI, but I'm sure that manually editing your "my.ini" is just as good.

Cheers
Nov 16 '05 #14

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Tiernan | last post by:
Hey everybody. I'm verry new to PHP and MYSQL and have been working on a form that when it is submitted stores the information into a mysql database. The main problem is that i'm trying to finish...
1
by: Anthony | last post by:
Hi all, I am having real problems allowing a client to connect to sql 2000 through enterprise manager.. I have tried all sorts but to no avail: From our local network all works fine.. Using...
4
by: gregsands | last post by:
Hi I have read all (ok most) of the posts relating to "Call to undefined function mysql_connect()", read the manual on PHP.net and done eveything thats ive been asked to do but cant get PHP to...
0
by: Aaron | last post by:
Hi Guys, I have a dbase installed on a network where the clints have linked tables to the database on the server. I found that i had to make some minor changes to the tables on the server...
6
by: tony010409020622 | last post by:
My WebForm1.aspx works fine when I connect via localhost, AND when I connect using the IP address. HOWEVER, NO ONE ELSE can connect using my IP address. Capitalization is correct, Firewall is off,...
0
by: Tillmann Neben | last post by:
As the topic already says, i just cant get it working. I am using "ftp-mode" to get the files onto the server instead of using frontpage extension. When I try to debug, VS tells me, that the...
2
by: yodboy | last post by:
hi there Im going nuts - any help appreciated trying to connect to access db over a network so far - I can connect to the db using the same odbc with excel I can connect to a copy of the...
0
by: =?Utf-8?B?Q2hpV2hpdGVTb3g=?= | last post by:
Hi, i got machine A that has sql2005, vs2005 project. project runs okay there. But when i copied that whole project folder to machine B, running sql2005, VS2005, edited the web.config file to...
3
by: =?Utf-8?B?Y29yeQ==?= | last post by:
i cant get the playstation 3 to connect to call of duty 4 online through the router but i am able to connect to the game online through the modem. I am able to still get on the internet through the...
6
flexsingh
by: flexsingh | last post by:
Hello there, I have constructed a option of choosing a court only available when member no = "0". This works fine and is in the first code: - <html> <head> </head> <body background="main...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.