SQL Navicat

azaxyo

New Member
Messages
4
Reaction score
0
Points
1
Navicat is a program that you can control SQL databases.I created my SQL to my site,but now i dont know which is the hostname/ip port username and password.How can i get these informations?I think i know the username and password.But what about hostname/ip and port?
 

homer693

New Member
Messages
35
Reaction score
0
Points
0
Try this:
Log into your cpanel on your site
Go to mysql databases
Create a new database
Create a new user
Go down to add user to database and add the user your just made to the database you just made
This is the normal info for sql on x10:
Hostname: localhost Port: 3306
 

azaxyo

New Member
Messages
4
Reaction score
0
Points
1
My sql is ok.Its already working and i added my tables.But i have to know the hostname/ip and port.I tried x10hosting.com but it said wrong username and password.So i think its not that.
 

xPlozion

New Member
Messages
868
Reaction score
1
Points
0
the ONLY host name x10 allows for mySQL access is localhost due to the firewall preventing remote access. as for the username and database name goes, don't forget your cpanel username prefix (cpuser_dbuser, cpuser_dbname) or you cannot login.
 
Top