hey everyone, i am trying to set up a connection to a mysql database on a remote server through sequel pro on my desktop. Its just a huge hassle for me to have to log into cPanel and then into phpMyAdmin to edit my databases. plus i would rather work on my desktop then through another window in my browser.
so anyway, is there a way that I can get the mysql socket info and port number from phpMyAdmin? or do i need to e-mail my host? I dont want to e-mail him if its something I can find myself, I dont believe this information was listed in the new account e-mail I got when I set up my hosting account. And a quick browse through phpMyAdmin and cPanel have revealed nothing... I have the IP, username and password (the only required fields) but its saying it cant connect. Maybe the socket and port number (optional fields) would help it along?
Any help, as always, is greatly appreciated!
Thank you so much!
so anyway, is there a way that I can get the mysql socket info and port number from phpMyAdmin? or do i need to e-mail my host? I dont want to e-mail him if its something I can find myself, I dont believe this information was listed in the new account e-mail I got when I set up my hosting account. And a quick browse through phpMyAdmin and cPanel have revealed nothing... I have the IP, username and password (the only required fields) but its saying it cant connect. Maybe the socket and port number (optional fields) would help it along?
Any help, as always, is greatly appreciated!
Thank you so much!