Results 1 to 2 of 2

Thread: Mysql remote access from MySQL Workbench

  1. #1
    Join Date
    Aug 2014
    Beans
    1

    Exclamation Mysql remote access from MySQL Workbench

    I have a newly install ubuntu installed the mysql server.

    After the basic config,

    I changed the my.cnf file and commented the bind_address

    I can start the server and added iptable for 3306.

    I also add the privileges to mysql server as follow:

    GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'
    IDENTIFIED BY 'P@ssw0rd' WITH GRANT OPTION;
    FLUSH PRIVILEGES;
    exit


    However after connected from the mysql workbench, it shows no database. But it seems that have login.

    Anyone have faced that or can help me?

    Thx!

  2. #2
    Join Date
    Nov 2008
    Location
    Boston MetroWest
    Beans
    16,326

    Re: Mysql remote access from MySQL Workbench

    What happens if you try to connect with the native command-line mysql client?"
    Last edited by SeijiSensei; August 19th, 2014 at 10:16 PM.
    If you ask for help, do not abandon your request. Please have the courtesy to check for responses and thank the people who helped you.

    Blog · Linode System Administration Guides · Android Apps for Ubuntu Users

Tags for this Thread

Bookmarks

Posting Permissions

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