MYSQL remote access please help

10 posts / 0 new

Topic locked

Last post

#1 Sat, 01/10/2009 - 05:45

Radster

MYSQL remote access please help

Hi there im trying to allow remote connection using the information below

[code:1]You can certainly do this in Virtualmin, although access is generally configured on a per-domain basis.

To set it up for existing domains, do the following :

1) Login as the master admin (root), and go to Webmin -> Servers -> MySQL Database, and click on User Permissions.

2) Click on 'Create a new user', and add an user with the username and password for the domain, but with the hosts set to something like 192.168.0.%

3) Go back to the main page of the MySQL module, and click on Database Permissions.

4) Click on 'Create new database permissions', and add a record for the domain's database and user, with all permissions selected, and with the hosts set to 192.168.0.%

If you want all new domains to get acesss from 192.168.0.% by default, go to System Settings -> Server Templates -> Default Settings -> MySQL Database, and fill in the 'Allowed MySQL client hosts' field with 192.168.0.%

I admit that this is a fairly complex process, which is why I plan to add a more user-friendly single-page form for managing MySQL remote hosts to in the next Virtualmin release.[/code:1]

however first off it seems MYSQL DATABASE SERVER module appears in the UNUSED MODULES list and according to the instructon above this should appear in WEBMIN > SERVERS can anyone tell me why this has happend. I have tried all instructions but nothing seems to work any help please.

#2 Sat, 01/10/2009 - 05:55

andreychek

Sometimes, a module can appear in "Un-used Modules" just until the modules are refreshed.

Try going into Webmin, and on the bottom-left, click "Refresh Modules".

As far as MySQL not doing what you'd hope, we can help, but you'll need to offer more info in addition to "it's not working" :-)

What are you trying exactly? What happens when you do it? Do you see any errors?

Also, in place of the "192.168.0.%" IP in the above, make sure you're adding your own IP address or network, rather than that one.
-Eric

#3 Sun, 06/07/2009 - 07:35

Radster

thanks for the prompt reply. Im wanting to access the database from a programme called SAM BROADCASTER however inserting the username password and database name returns a unable to connect to host error.

if i try to telnet into my ip and port 3306 it comes back with this

@
5.0.51a-3ubuntu5.4â

#4 Sun, 06/07/2009 - 07:35

Radster

if i try to telnet into my ip and port 3306 it comes back with this

@
5.0.51a-3ubuntu5.4â

#5 Sat, 01/10/2009 - 06:17

andreychek

I might start here --

Rather than using SAM BROADCASTER, try connecting to the remote database using the command line MySQL program (you might have to install MySQL on this system if it isn't already, but it should make troubleshooting a bunch easier).

Once it's installed, run:

mysql -h hostname_to_connect -u username -p

And see if that gets you in.

The above will rule out all sorts of issues, and will help nail down if it's a MySQL permissions issue.

Also, be absolutely certain about the IP address you added that you're connecting from.
-Eric

#6 Sat, 01/10/2009 - 11:03

Radster

hi again andreychek

ok i successfully connectd to the database using putty using the ip of the server this worked fine without any problem.

#7 Sat, 01/10/2009 - 11:29

Radster

i did try to edit my post however it told me i had found a bug woo hoo....

anyway tried again in sam and still no joy followed the instuctions again down to the letter and no joy what am i doing wrong the weird thing is that im actually remote connecting to the mysql using my ip address from my sam programme so im stumped.

#8 Sat, 01/10/2009 - 13:34

Radster

Hi there again sorry for the triple post hwoever without being able to edit the previous post i dont have much option. ok so a little more digging i managed to get it work however i have another issue.

in the user permissions i set access to ANY this enabled the user to connect remotly to the database however this then stopped apache from working i change it back to localhost or my wan ip and then apache cam back but was not able to connect remotly to the mysql server any information would really be appreciated.

#9 Sun, 06/21/2009 - 06:33

milvers

I followed Radster's first post on how to connect to remote Mysql server I am on dynamic IP as I think it caused headaches for me to connect to my mysql server via Dreamweaver 8's Database function? Maybe.

I did edited the database remote hosts for test(account) by adding the IP address of mysql server, saved it then Went back to Webmin -Server- MySQL Database Server> User Permission and created an username "test" -Host to "Any" and saved it

-Database Permissions> Created new database permission>  
                        -Databases> selected Test2 
                       -Username> Test 
                        Hosts> IP address of MySQL server

Hopping that Dreamweaver 8 will connect to the database with my newly created username "Test" and it return a evil message "Access Denied, The File may not exist, or there could be a permission problem" Again I had received suggestion from Eric aka "andreychek" but I need better guide to fix the problem with Dreamweaver or mistake I may had previously?.

Anyone that can help me out would be great!

Aka Wilbur

#10 Sun, 06/21/2009 - 08:05

ronald

dreamweaver will put a folder with files on your server and connect through there (locally). You'll be better off following dreamweavers instruction on how to do this. I made successful connection myself in the past but was a bit of searching in their docs.

Topic locked