Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2006
    Posts
    8

    Unhappy Unanswered: Urgent, mySQL remote access problem.

    Hi,

    I've a mySQL server running on freeBSD Box and I cann't connect myself to mySQL with root user from an external PC, but with the "informix" user I can do it.

    This are my user and db tables (The passwd isn't real):
    I've tried from my PC(WinPX) : sistemas1.dom.cu

    mysql> select host, user, password from user order by host desc; +------------------+--------+---------------------------------+
    | host | user | password |
    +------------------+--------+---------------------------------+
    | sistemas1.dom.cu | | |
    | localhost | root |*EF9E58BF0792C14192C8CD7A |
    | localhost | | |
    | localhost | jabberd2 |*135D0CFD9A70B3032C179A49EE7 |
    | localhost | informix |*F7C661CB9EDE1B60443761D88D6FF |
    | gw.dom.gcc.cu | | |
    | %dom.cu | www |*D34BBEBD1265092FD451E9CEA86ABC |
    | %dom.cu | informix |*9FF7C661CB9EDE1B60443761D88D6FF |
    | %dom.cu | root |*508ED8DEF9E58BF0792C14192C8CD7A |
    +-----------------+--------+--------------------------------------+

    mysql> select host, db, user from db;
    +-----------+----------+----------+
    | host | db | user |
    +-----------+----------+----------+
    | % | mttsa | www |
    | % | mtts | informix |
    | % | test | |
    | % | test\_% | |
    | localhost | jabberd2 | jabberd2 |
    +-----------+----------+----------+

    What do I miss?

  2. #2
    Join Date
    Feb 2005
    Location
    Mumbai, India
    Posts
    161
    Code:
    CREATE USER 'root';
    SET PASSWORD FOR root = PASSWORD('mypassword');
    GRANT ALL ON *.* TO 'root'@'%';
    FLUSH  PRIVILEGES;
    OR
    Code:
    INSERT INTO `user`
    ( `Host` , `User` , `Password` , `Select_priv` , `Insert_priv` , `Update_priv` , `Delete_priv` , `Create_priv` , `Drop_priv` , `Reload_priv` , `Shutdown_priv` , `Process_priv` , `File_priv` , `Grant_priv` , `References_priv` , `Index_priv` , `Alter_priv` , `Show_db_priv` , `Super_priv` , `Create_tmp_table_priv` , `Lock_tables_priv` , `Execute_priv` , `Repl_slave_priv` , `Repl_client_priv` , `Create_view_priv` , `Show_view_priv` , `Create_routine_priv` , `Alter_routine_priv` , `Create_user_priv` , `ssl_type` , `ssl_cipher` , `x509_issuer` , `x509_subject` , `max_questions` , `max_updates` , `max_connections` , `max_user_connections` )
    VALUES
    ('%', 'root', 'mypassword', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', '0', '0', '0', '0');
    MySQL 5.1

  3. #3
    Join Date
    Jan 2006
    Posts
    8

    Thumbs up

    Thank you very much!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •