Details for SQLyog

[the_king_dollars]

As my phpMyAdmin doesn't work. I want to use SQLyog. But I don't know the details.
So can you please tell me what to input for the details? Here is what I need:

Username:
Password:
Host:
Port:
Database:

P.S. For the host, don't just tell me "localhost", I'm using the software directly from a computer. (Not using a webserver.)

 

[mattyranks]

well to start with the databases are only (i think) accessible via localhost ON the WEB SERVER for security; so you won't be able to do it from home

 

[the_king_dollars]

So do you know how do I install SQLyog on the web server?

 

[Derek]

Eh i think its admins only i dunno

 

[Simie]

You have to add your IP address to the allowed connections thing in cPanel.
Screeny:

Username: The username, like "tkd_USERNAME"
Password: the database password
Host: You're domain name
Port: Leave default
Database: The database, like "tkd_DATABASE"


Hope this helps

 

[the_king_dollars]

It didn't work for me. I tried one of my usernames and my main one 'tkd' . None worked. Do you know what should I change?
Thank you anyway.

 

[Micro]

Use this:

Username: The username, like "YOURCPANELUSERNAME_YOURDBUSERNAME"
Password: the database password
Host: You're domain name
Port: Leave default
Database: The database, like "YOURCPANELUSERNAME_YOURDATABASENAME"

 

[the_king_dollars]

You have to add your IP address to the allowed connections thing in cPanel.

Where is it and how do I do it?

 

[t2t2t]

Cpanel -> MySQL databases -> Access Hosts (pretty bottom, above phpMyAdmin link) -> Add there your IP (don't know? Click Here)

 

[dest581]

And if that doesn't work, just upload a copy of phpmyadmin to your site (password protect it or something). That copy will work.

 

[the_king_dollars]

OK. I now know how to use SQLyog. Thank you for your time and help.