remote access to MYSQL

[HeadMetal]

I have spoken with a livechat tech (Daniel) and have been able to get my account (somelcom) to connect to the dbs I have created, but I am unable to execute queries.

I have tried both Navicat and SQLyog with no success. My IP is 68.149.37.120 and I have also sent a email to support@cirtexhosting.com (subject line: somevil MYSQL remote inquiry)

I constantly check my email (fishern@macewan.ca) if an admin fixes this issue...

thanks in advance guys...I am quite enjoying the pleasant tech support.

Nik

[Cirtex Joshua]

Alright buddy, I've added your IP to the allowed hosts, and updated settings, give it 5 minutes or so, and try again.

[HeadMetal]

still getting connection error:
"Query:


Error occured at:2007-06-14 22:46:52
Line no.:0
Error Code: 1044 - Access denied for user 'somelcom'@'68.149.37.120' to database 'somelcom_test'"

again, I can connect...just cannot execute

[Cirtex Joshua]

Username would not be like that, username would be created also in CPanel database section and would be formatted same as database name (username_dbusername), also make sure to give full privs in CPanel.

(Signing off after 16 hr day, John will reply from here)

[HeadMetal]

I grabbed a few screenshots from Navicat.

in screen 1 I tried to access the server as per Joshua's instructions using username_db...did not connect as it needs my actual username and password to my account like a ftp

http://www.somevil.com/1.bmp

http://www.somevil.com/2.bmp

in the third shot I got access to the mysql, but am unable to authenticate to the database

http://www.somevil.com/3.bmp

4th pic is just to show my CP settings are set to all access

http://www.somevil.com/4.bmp


please let me know if you need any further screens. I can even get some from SQLyog, where i connect but get the following message when executing a query:
"Query:


Error occured at:2007-06-14 22:46:52
Line no.:0
Error Code: 1044 - Access denied for user 'somelcom'@'68.149.37.120' to database 'somelcom_test'



EDIT: I did notice my typo on the db name...fixed somelcom_clipshare, but got the same error as above

[Cirtex Joshua]

What kind of query are you trying to run?

[HeadMetal]

I am trying to execute a sql (add it to the db)

says I do not have permissions

[Cirtex Joshua]

Well, you sure got me :)

Now, I dont use this program or anything, but I know if you're going to do anything to the database, you have to use the username that is actually authenticated to the database, which is somelcom_test and whatever password you created for it. But when you try that, the program you're using doesn't seem to like that setup - So I really don't know where to go from here :(

[HeadMetal]

can you recommend any 3rd party apps that would work or others have tested that work with your server setup? I am not as fond of phpadmin as I could be ;)

I like the gui interface...hence the initial ?

[Cirtex Joshua]

I just use command line, but then again I'm a geek - I'll move this to our webmasters forum, I know others use programs like this, because I'm always adding IP's to whitelist, so I'm sure someone can help.

[HeadMetal]

hope to get a response soon <bump>

thanks in advance