| Author |
how do i find MySQL Server name?
|
|
| Pavelthesecond 2004-06-05, 11:15 pm |
| i'm setting up a mysql connection. however, i cant find the name of my MySQL
Server. anybody know where its located.
i've setup a testing server, and remore server. both on the same url. i use
FTP access.
i have setup a mysql database through my web hosting company.
i tried using the url of my site and of the mysql databasel. doesn't work. i
get an unidentifed error has accurred message.
in Dreamwaver help is says the address could be an IP address. any ideas as to
how i can find it?
thanks alot.
| |
|
| 99% of the time, it's going to be:
localhost
If that doesn't work, check with your host's FAQ or any Control Panel you
might have for hosting.
> i tried using the url of my site and of the mysql databasel. doesn't work. i
> get an unidentifed error has accurred message.
| |
| twoCan's 2004-06-05, 11:15 pm |
| Maybe this might help
http://www.dwteam.com/articles/ado/index.asp
tintin
"Pavelthesecond" <webforumsuser@macromedia.com> wrote in message
news:c9sbfd$7vc$1@forums.macromedia.com...
> i'm setting up a mysql connection. however, i cant find the name of my
MySQL
> Server. anybody know where its located.
> i've setup a testing server, and remore server. both on the same url. i
use
> FTP access.
> i have setup a mysql database through my web hosting company.
> i tried using the url of my site and of the mysql databasel. doesn't
work. i
> get an unidentifed error has accurred message.
> in Dreamwaver help is says the address could be an IP address. any ideas
as to
> how i can find it?
> thanks alot.
>
>
| |
| Pavelthesecond 2004-06-05, 11:15 pm |
| nop, localhost doesn't do the trick.
| |
|
| then check your hosting's FAQ/Support section. Or look in "control panel" if
there is one. Or contact your support directly.
or look back thru any emails/info where the username/password to the MySQL
db was given to you.
> nop, localhost doesn't do the trick.
| |
| Pavelthesecond 2004-06-05, 11:16 pm |
| the FAQ are no help. Control Panel is from where i setup my database. all it
tells me is the name of the database, username and password of users using it
and the url of the database. (putting that url for the server address returns
404 error)
i've emailde the support but they said
"The only thing we have to remember regarding the database are the following:
Hostname: local host
Domain name: your domain
DB username
DB password"
they never sent me any email regarding mysql database password and username
becouse i created the database through their control panel.
hope this helps
| |
|
| okay, you are using CPanel or similar?
hostname is probably localhost
Lowercase, one-word.
before getting stuck on this item---
Have you checked that your settings for the Testing Server are working?
If there is an error in THOSE settings, you'll get an error trying to create
a db connection.
Have you set up a local testing server, or are you using ftp and your remote
host as the testing server?
Does the "test" button on the Testing server pane of the site definition
work?
Does preview in browser work for .php pages? (assuming it is a php/MySQL
site)
> the FAQ are no help. Control Panel is from where i setup my database. all it
> tells me is the name of the database, username and password of users using it
> and the url of the database. (putting that url for the server address returns
> 404 error)
> i've emailde the support but they said
> "The only thing we have to remember regarding the database are the following:
> Hostname: local host
> Domain name: your domain
> DB username
> DB password"
>
> they never sent me any email regarding mysql database password and username
> becouse i created the database through their control panel.
>
> hope this helps
>
| |
| Dave Farmer 2004-06-05, 11:17 pm |
| On Sat, 5 Jun 2004 11:40:29 +0000 (UTC), Pavelthesecond wrote:
> i'm setting up a mysql connection. however, i cant find the name of my MySQL
> Server. anybody know where its located.
> i've setup a testing server, and remore server. both on the same url. i use
> FTP access.
> i have setup a mysql database through my web hosting company.
> i tried using the url of my site and of the mysql databasel. doesn't work. i
> get an unidentifed error has accurred message.
> in Dreamwaver help is says the address could be an IP address. any ideas as to
> how i can find it?
> thanks alot.
I had the same trouble with my hosting company and there was nothing in the
FAQ or other help sections about this. I got the answer by contacting their
support section.
I created a database with a database name no problem but the missing bit
was that it had to be activated and this actually gave it a new "system"
name in a format decided by the hosting company.
Look for something similar in the control panel or contact your support
people again and ask whether they operate the same kind of activation
system.
| |
|
| this may not be true in all cases, but generally, if the mysql is on the
same machine, then using localhost as the mysql Server is correct.
If one of the other fields in the Connection box are wrong, then you will
get the unidentified error.
so- can you triple-check that you are using the correct:
User Name
Password
Database
***NOTE- this username and password may OR may not be the same as your FTP
username/password. It is probably NOT the same.
If you have CPanel or Control Panel with a mysql tab, in the mysql page
almost all control panels will list the names of Your DATABASES and sample
connection files to them.
It will also list what USERS have rights to connect to that db.
Finally- submit a support ticket or other method to contact your host, so
they can straighten this out for you.
> still can't connect to my database.
> "localhost" Lowercase, one-word. returnes unidentifed error has accurred
> message.
>
> also, i know my database name. its the mysql server name i'm having trouble
> with. i don't know what to type in the mysql server field under MySQL
> Connection.
| |
| Pavelthesecond 2004-06-06, 2:14 pm |
| Dreamweaver connects to my test server just fine. i can even upload file to my
testing server.
i have triple checked all of my site settings.
my testing site is on remore server, i use FTP.
the "test" button works just fine.
preview in Browser works fine for a .php document.
still can't connect to my database.
"localhost" Lowercase, one-word. returnes unidentifed error has accurred
message.
also, i know my database name. its the mysql server name i'm having trouble
with. i don't know what to type in the mysql server field under MySQL
Connection.
| |
| Pavelthesecond 2004-06-09, 6:02 pm |
| ok, i contacted my host company's support and they said
do not allow third party software to connect to database. You will need to
use your phpmyadmin to manage your mysql database.
this is very very bad.
that means i'll have to make .php document in Dreamweaver without a recordset.
is that even possible?
| |
|
|
> ok, i contacted my host company's support and they said
> do not allow third party software to connect to database.
If they said they don't allow remote connections to the mysql database, then
that confirms that you should use localhost as the servername.
You will need to
> use your phpmyadmin to manage your mysql database.
> this is very very bad.
> that means i'll have to make .php document in Dreamweaver without a recordset.
> is that even possible?
You CAN use dreamweaver to connect to this- dreamweaver actually uploads a
file to the server, it's not making a remote connection. It will work.
What it DOES mean, is that one or more of the other three bits of info to
make the db connection (database name, username, password) is what is wrong.
Go into your Control Panel.
Go to the mysql tab.
Does it list your database(s) ?
If no- use the buttons to create one...
If yes- is that the exact case sensitive database name you are using in
dreameaver? Exactly? Copy the db name from the page and paste it into
dreamweaver's dialog box.
Does it give an example connection string, with a username/password?
If not- Is the database name "clickable" and will take you to a new screen
where that info is listed?
Or- have you assigned any Users to this database?
In otherwords- Where did you come up with the info on the Username/Password?
Repeating again, you have to set up a User for the database. It is NOT your
FTP username/password to connect to it.
| |
| Tim Litwiller 2004-06-09, 6:03 pm |
| No, dreamweaver doesn't make direct connections to the mysql database in
the PHP server model.
It uploads a script to your web hosting space and proxys the database
queries thru it.
So what that means is: It isn't a third party software connecting to
the database it is a web page on your hosting that does the connecting.
dreamweaver looks at the testing server http:// path that you have set
and adds _mmServerScripts/
so you need to make sure that the ftp path is set to match
for example www.myserver.com
testing server is set to www.myserver.com
ftp folder to the web root on this site is ftp.myserver.com/webroot
if I set the ftp path to nothing it uploads the _mmServerScripts folder
to the incorrect place and I can't connect - so I need webroot/ in the
ftp path to force dreamweaver to upload the _mmServerScripts/ folder in
the correct place under the web root so that dreamweaver can find the
scripts it uploads.
Pavelthesecond wrote:
> ok, i contacted my host company's support and they said
> do not allow third party software to connect to database. You will need to
> use your phpmyadmin to manage your mysql database.
> this is very very bad.
> that means i'll have to make .php document in Dreamweaver without a recordset.
> is that even possible?
>
| |
| Pavelthesecond 2004-06-11, 11:14 pm |
| my control panel lists the DB name, its user name and password.
i tryed those with localhost for the server name. still i get an unadanified
error and can't make the connection.
i'm 100% possitivly sure that the DB name, my username and password are
correct.
|
|
|
|
| Copyright 2003 - 2009 forum4designers.com Software forum Computer Hardware reviews |