Results 1 to 3 of 3

Thread: mysql server hostname

  1. #1
    Join Date
    Feb 2008
    Beans
    34

    mysql server hostname

    Playing around with managing my own VPS.

    How would set it up so I connect to my mysqlserver remotely from like mysqlAdministator on my computer at home ?

    I did the default mysqlserver package...

  2. #2
    Join Date
    Jun 2007
    Location
    Australia
    Beans
    332
    Distro
    Ubuntu Studio 12.04 Precise Pangolin

    Re: mysql server hostname

    there is to ways I use to access mysql server remotely are the following
    1.putty for mirosoft machines
    2. I my linux laptop ssh from the terminal eg gishaust@mycomputernameoripaddress

    note that your server would need ssh server. Using putty or you have to make sure that you open ports and firewall is another issue on your server. But you can do it. It also depends on your work situation any what type of access that you are allowed to use???

    3 You can use phpadmin that will allow you to access through a webpage.
    It doesn't aways happen straight away. But time has a way of leveling everything!!!

  3. #3
    Join Date
    Mar 2006
    Location
    Williams Lake
    Beans
    Hidden!
    Distro
    Ubuntu Development Release

    Re: mysql server hostname

    Another way to setup remote access is like this open mysql in a terminal then type:

    Code:
    grant all privileges on *.* to <user>@'%'
    identified by '<password>' with grant option;
    where <user> is you username without the brackets and <password> is your mysql password without the brackets.

    I not sure if this will work from outside your local network, but give it a try.

    Jim

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
  •