#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2000
    Posts
    79
    Rep Power
    15
    I have a MySQL installed on Win98,
    server=localhost,username=root,
    When I run mysqlgui to connect MySQL-Win98 on the same PC machine,It works fine.
    But I type the IP or hostname in the server field(port=3306),mysqlgui can't connect the mysql server on Linux.
    Anything wrong ?
  2. #2
  3. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,648
    Rep Power
    4493
    Are you sure it's not just taking a long time to download all of the data. If you're on a virtual server, it's going to download all of the information about all of the databases. Sometimes this takes awhile. I used MysqlAdmin and I thought it wouldn't connect either, until I just left it running one time and it eventually came up. Over a dial-up it just takes a while to get all of that information because there could be a lot of databases.

    My $0.02.

    ---John Holmes...
  4. #3
  5. No Profile Picture
    Carpe Diem
    Guest
    Devshed Newbie (0 - 499 posts)
    By default mysql sets up the root user so no other client can connect to it, only the local host.

    So you (or your host) need to use the grant command to allow connections from other computers.

    The command is :-
    grant all on database.* to user@% identified by 'password';

    Just change the database/user/password and it will allow you to connect.




    ------------------

    Regards
    Darren
    --
    http://www.php4hosting.com/ $
    http://www.php4hosting.co.uk/
    PHP/MySQL Enabled Hosting/Dedicated Servers

Similar Threads

  1. Mysql problem.
    By Nik in forum MySQL Help
    Replies: 54
    Last Post: December 21st, 2006, 07:02 PM
  2. mysql connect issue
    By slen in forum MySQL Help
    Replies: 1
    Last Post: February 17th, 2004, 04:33 AM
  3. Replies: 1
    Last Post: February 5th, 2004, 12:50 AM
  4. how to connect the oracle server
    By arihandro in forum Oracle Development
    Replies: 1
    Last Post: February 4th, 2004, 09:30 AM
  5. tranfer tables from mysql to postgresql in linux
    By muthayalap in forum Java Help
    Replies: 0
    Last Post: February 3rd, 2004, 11:13 AM

IMN logo majestic logo threadwatch logo seochat tools logo