Thread: Mysql problem.

Page 1 of 4 123 ... Last
  • Jump to page:
    #1
  1. Contributing User
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    Jun 2003
    Location
    Thessaloniki
    Posts
    1,402
    Rep Power
    0

    Mysql problem.


    hello i use xp and i have downloaded mysql 5 server and clients.
    when i try to connect to the server to create a new database i get the following error:


    C:\Program Files\mysql\bin>mysqld-nt.exe

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

    C:\Program Files\mysql\bin>


    do you know why?

    i also cannot start mysql as a service. it exists in the services but cannot start itself when the system boots

    i get "The proccess terminated unsuccesfuly. Can you help me?"

    Help me out please....
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    229
    Rep Power
    15
    Unless you enjoy inflicting pain upon yourself,
    you would probably be better
    served downloading version 4.0.17 instead
    of development version 5.0. There's even
    a windows self-installer that sets everything
    up in about 2 minutes if you use the
    production version.

    That said, you will find the cause of your
    problem listed in the MySQL error log located at
    c:\mysql\data\<host_name>.err
    Check it out. What does it say?
    Better yet, just use a production release.
  4. #3
  5. Contributing User
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    Jun 2003
    Location
    Thessaloniki
    Posts
    1,402
    Rep Power
    0
    Here is the log file you requested! can you understand anything? because i cant!

    InnoDB: The first specified data file .\ibdata1 did not exist:
    InnoDB: a new database to be created!
    040201 21:24:03 InnoDB: Setting file .\ibdata1 size to 10 MB
    InnoDB: Database physically writes the file full: wait...
    040201 21:24:04 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
    InnoDB: Setting log file .\ib_logfile0 size to 5 MB
    InnoDB: Database physically writes the file full: wait...
    040201 21:24:05 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
    InnoDB: Setting log file .\ib_logfile1 size to 5 MB
    InnoDB: Database physically writes the file full: wait...
    InnoDB: Doublewrite buffer not found: creating new
    InnoDB: Doublewrite buffer created
    InnoDB: Creating foreign key constraint system tables
    InnoDB: Foreign key constraint system tables created
    040201 21:24:22 InnoDB: Started; log sequence number 0 0

    i did download mysql 4 at the first time but i had the exact same problems with that version as well.
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    229
    Rep Power
    15
    Are out of disk space?
    Actually, I don't see any errors here at all.
    Are you sure there's nothing else indicating an error?
    What happens when you double-click (open) winmysqladmin.exe?
  8. #5
  9. Contributing User
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    Jun 2003
    Location
    Thessaloniki
    Posts
    1,402
    Rep Power
    0
    no i am not rin out of disk space i have 10 gb free space on c: and yes mysqladmin is working ok

    i just cant understand why am i getting this error, can you?

    C:\Program Files\mysql\bin>mysqld-nt.exe

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


    whats wrror 2003 all about?

    what can i do to connect?
  10. #6
  11. Contributing User
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    Jun 2003
    Location
    Thessaloniki
    Posts
    1,402
    Rep Power
    0
    i also found this in winmysladmin

    Version: '5.0.0-alpha-nt' socket: '' port: 3306
    C:/Program Files/mysql/bin/mysqld-nt.exe: ready for connections.


    but why on command line tries to coonect to this port 10061 and not on 3306???

    Can't connect to MySQL server on 'localhost' (10061)
  12. #7
  13. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    229
    Rep Power
    15
    MySQL seems to have installed just fine.
    You just can't connect because it didn't
    install on default port 3306.

    Try starting up the mysql client program with
    your port defined to 10061:

    mysql -u <yourusername> --port=10061
  14. #8
  15. Contributing User
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    Jun 2003
    Location
    Thessaloniki
    Posts
    1,402
    Rep Power
    0
    C:\Program Files\mysql\bin>mysql -u root --port=10061
    ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

    why did it install itself to port 10061 instead of the default port?

    why still i cant connect?

    how do i know if user root exists?

    how can i turn it to coonect on the default port?

    thanks for your help man!
  16. #9
  17. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    229
    Rep Power
    15
    I don't know why it installed to a non-standard port.

    User 'root' is always installed whenever you do a
    fresh MySQL install.
    You should also try:
    mysql --port=10061

    What happens when you telnet to the 10061 port? In the MSDOS console window, type:

    telnet localhost 10061

    If MySQL is installed you should see the MySQL
    version number. Just hit the carriage return a
    couple of times to get out of the telnet session.

    If you are installing a version of MySQL directly
    over a previous version of MySQL I recommend
    you COMPLETELY delete the old MySQL directory
    (AND my.ini file located in your WINDOWS directory) prior to installing a new version of MySQL.

    You never indicated whether you are getting a
    green stoplight in the bottom-right corner of your
    screen when you run winmysqladmin.exe.
  18. #10
  19. Contributing User
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    Jun 2003
    Location
    Thessaloniki
    Posts
    1,402
    Rep Power
    0
    actually today after waking up and booted my pc mysql was working fine suprising me! was accepting connections to the default port 3306 and winmysqladmin light was green whether yesterdays was red!

    i was able to create my databses but i cannot longer see mysqld on the services thar runs in my pc on the administative panel? why it doesn exist there?
  20. #11
  21. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    229
    Rep Power
    15
    I've never heard of or seen this problem where the
    service doesn't show up. Sorry.
    Glad to hear your server works, though.
  22. #12
  23. Contributing User
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    Jun 2003
    Location
    Thessaloniki
    Posts
    1,402
    Rep Power
    0
    problem again unfortunately! after i rebooted my pc i have the usual problems can tconnect to mysql neither on 3306 or 10061 port! service cant start and winmysqladmin shows only red when i try to activate it!

    i removed the software completele and reinsta;;ed it but still have the smae problem!

    please my frined help on this. i know it became tired but i reall y need your help! it is the first time a encounter with this erros all other time mysql was succesfully insta;lled and run!

    any ideas on what i can do to make it work?
  24. #13
  25. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    229
    Rep Power
    15
    The last 20 or so lines in the error log should
    shed some light on the problem.
  26. #14
  27. Contributing User
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    Jun 2003
    Location
    Thessaloniki
    Posts
    1,402
    Rep Power
    0
    here it is mate!


    InnoDB: The first specified data file .\ibdata1 did not exist:
    InnoDB: a new database to be created!
    040201 21:24:03 InnoDB: Setting file .\ibdata1 size to 10 MB
    InnoDB: Database physically writes the file full: wait...
    040201 21:24:04 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
    InnoDB: Setting log file .\ib_logfile0 size to 5 MB
    InnoDB: Database physically writes the file full: wait...
    040201 21:24:05 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
    InnoDB: Setting log file .\ib_logfile1 size to 5 MB
    InnoDB: Database physically writes the file full: wait...
    InnoDB: Doublewrite buffer not found: creating new
    InnoDB: Doublewrite buffer created
    InnoDB: Creating foreign key constraint system tables
    InnoDB: Foreign key constraint system tables created
    040201 21:24:22 InnoDB: Started; log sequence number 0 0
    040202 13:50:32 InnoDB: Database was not shut down normally!
    InnoDB: Starting crash recovery.
    InnoDB: Reading tablespace information from the .ibd files...
    InnoDB: Restoring possible half-written data pages from the doublewrite
    InnoDB: buffer...
    040202 13:50:32 InnoDB: Starting log scan based on checkpoint at
    InnoDB: log sequence number 0 43634.
    InnoDB: Doing recovery: scanned up to log sequence number 0 43634
    040202 13:50:33 InnoDB: Flushing modified pages from the buffer pool...
    040202 13:50:33 InnoDB: Started; log sequence number 0 43634
  28. #15
  29. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    229
    Rep Power
    15
    According to the error log the reason why
    you are having problems is the MySQL
    server was not shut down prior to you
    turning off your computer.

    It looks like MySQL was able to restore
    itself OK, though, so it should be functional.

    You can shut down the MySQL server manually this way:

    mysqladmin -u root -p shutdown

    If I were you I would be deleting this version
    of MySQL and installing a production version. I don't see anything obviously
    wrong here that points to your underlying problem.
Page 1 of 4 123 ... Last
  • Jump to page:

IMN logo majestic logo threadwatch logo seochat tools logo