Connecting to Database with outside Database Mngmt Software
Posted:
Fri May 15, 2009 1:19 pmby jepps3
I have a outside management viewer/editor for SQL that is able to connect to a SQL database. I just need to know the following:
Default databse host or IP?
defualt port?
default user (cron?)
default pass (1234?)
database name?
driver class for database?
Thanks in advance!
Posted:
Tue May 19, 2009 9:48 pmby williamconley
you'll need the IP of your server ... i can't give you that.
yes. the default port for MySQL. Easily looked up on many sites. And can be changed. You may need to alter your sql permissions to allow a user to access the system from another IP (generally not allowed by deffault)
create a user specifically for this or use root if you're feelin lucky (exposing the "root" mysql user to internet access will work and will also open you EXTREME hacking possibilities, so it's better to learn how to make a user JUST for this purpose with READ ONLY access to ONLY what you want to view with your new toy)
database: asterisk
driver class? MySQL