Linux - Networking This forum is for any issue related to networks or networking.
Routing, network cards, OSI, etc. Anything is fair game. |
Notices |
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
Are you new to LinuxQuestions.org? Visit the following links:
Site Howto |
Site FAQ |
Sitemap |
Register Now
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
|
 |
10-24-2005, 03:22 PM
|
#1
|
Member
Registered: Apr 2005
Distribution: Fedora
Posts: 33
Rep:
|
MySQL and Dreamweaver MX
I am having trouble with dreamweaver connecting to mysql. i amr unning mysql 5 and php 5 on a apache server, i have tested the php and it works.The mysql is running but dreamweaver does not want to connect to the databse specified, it give the error "unidentified error has ecoured", this happens when i try connecting to a databsse using the desing mode of dreamweaver when i enter the code mode and type;
$host="hostname"
$DB="database"
$user="username"
$passwd="passwd"
mysql_connect($host, $user, $passwd)
or die('Unable to connect to server ' . $host);
he gives me a white page and no error, this must mean he finds the server but cant connect, so please if anyone can shed some light one the situation...
|
|
|
10-24-2005, 04:11 PM
|
#2
|
Senior Member
Registered: Feb 2002
Location: Szczecin, Poland
Distribution: Gentoo, Debian
Posts: 2,458
Rep:
|
What is showing in the mysql logs?
You need to see if mysqld sees the connection, then track it from there..
Can you connect with the mysql client ok?
|
|
|
10-24-2005, 04:20 PM
|
#3
|
Member
Registered: Apr 2005
Distribution: Fedora
Posts: 33
Original Poster
Rep:
|
okay, give me the deatils, how do i connect wiht client, how do i check logs, im a real noob wiht linux, only know a bit so..details
|
|
|
10-24-2005, 05:06 PM
|
#4
|
Senior Member
Registered: Feb 2002
Location: Szczecin, Poland
Distribution: Gentoo, Debian
Posts: 2,458
Rep:
|
I am assuming mysqld is installed on a separate Linux machine..
Logs are in /var/log/mysql.log
To view it while it is running, do tail -f /var/log/mysql.log in a console as root.
The client name and password need to be given permission to bind to an mysql table.
If this sounds foreign to you, it probably hasn't been done yet..
From a console on the server do /bin/mysqladmin version & /bin/mysqladmin variables to make sure you can connect to the server from it's local user.
Next is bin/mysqlshow
then bin/mysqlshow mysql
then bin/mysql -e "SELECT Host,Db,User FROM db" mysql
These prove that the server can be talked to from a local connection.
Next look at netstat -tlnp and see if it is listening on more than only 127.0.0.1:3306
If it is just 127.0.0.1 check /etc/mysql/my.cnf and change the line "bind-address = 127.0.0.1" to the correct interface ip number.
Also check if the line "# skip-networking" has the hash at the beginning. If not, put in a hash.
To edit the file, use nano or pico. eg nano /etc/mysql/my.cnf or a text editor from the menu.
Then restart mysqld and test again.
|
|
|
11-11-2005, 02:20 PM
|
#5
|
Member
Registered: Apr 2005
Distribution: Fedora
Posts: 33
Original Poster
Rep:
|
i tried that, but still i get the error. i tried telnet <mysqlip> 33306 on my windows machine, but it made an error, what can be wrong there, maybe that is the cuase of my issue?
|
|
|
All times are GMT -5. The time now is 10:36 PM.
|
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.
|
Latest Threads
LQ News
|
|