Forums

This topic is locked

Yet another MX/MySQL connection

Posted 05 Nov 2003 22:44:15
1
has voted
05 Nov 2003 22:44:15 Carol Andrejak posted:
I've searched all the postings for my problem and many come close but after trying all the suggestions, still no luck connecting. Here is my setup:

RedHat 8/PHP/MySQL on server. Months ago I was able to connect to the database just fine and everything worked. However, in order to get a calendar program to work I had to uninstall and reinstall MySQL so certain files were where the required Perl/mysql module expected them to be. First MySQL install was from binaries. Second was from RPMs. Finally got Perl module, MySQL, calendar program all working.

Now I can't get DWMX to connect correctly. *sigh*

I can telnet in to the database to set up tables, etc. OK so I know my user id and password is correct. Also, FTP works fine in MX for normal ops.

Site definition:
Remote Info
FTP host = www.my.domain
Host dir = ../../usr/webpages/practicedir/
login = me
password = yup

Testing server
All the same info except
URL prefix = www.my.domain/

Connection tests to remote and testing servers are successful in site definition window. So...

DB Connection info
Name = connPractice
MySQL Server = www.my.domain
User name = me
Password = yup
Database =

and here's where it doesn't work. When I click on Select I get:
1045 Access denied for user me@[url]me@[url]http://www.my.domain[/url] (Using password 'YES')

BUT if I try to connect WITHOUT a password, it connects but all I see is the test database which I know is wrong because I have four different databases that should show up. Also I tried the URL Prefix with and without the /practicedir/ at the end. Still no luck. Also I tried doing away with the Host dir in the testing server window but that didn't work either.

I'm open for any ideas.....

Thanks.


I may look like I'm doing nothing but at the cellular level I'm really quite busy.

Replies

Replied 06 Nov 2003 00:52:56
06 Nov 2003 00:52:56 Janusz Jasinski replied:
U set priv. for the database didn't you?

Silly question, but I have phucked up many times this way in the past

Janusz

======================
janusz.monkey-it.co.uk

ASP | VBScript | IIS 5.1 | Windows XP Pro | Linux Redhat 9 | SuSE 9 Pro | Linux FreeBSD 4.9 | PHP 5.0.0 Beta 2 | MySQL 4.0 | Apache 2.0.48 | Macromedia Studio w/t Flash 2004 | Microsoft Office Pro 2003 | Mozilla Firebird 0.7 | IE 6 | B.O.R.E.D @ HoMe
Replied 06 Nov 2003 15:57:49
06 Nov 2003 15:57:49 Carol Andrejak replied:
I just telnetted in and double checked all the privs and my user has everything but the Grant priv. When I set up me as a user, I did two commands, one for @'%' and one for @localhost. Then I did a flush privileges. (by the book)

Basically I can do anything I want through telnet but I just can't get MX to connect. (grrrrr)

Anything else I can try?

I may look like I'm doing nothing but at the cellular level I'm really quite busy.
Replied 06 Nov 2003 23:15:38
06 Nov 2003 23:15:38 Carol Andrejak replied:
An update on my problem:
Today just for the heck of it, I tried creating a connection using root and my root password. This time the connection worked and I see all the various databases.

So if I can connect as root but not as my regular user, what does this tell me as far as troubleshooting???

I may look like I'm doing nothing but at the cellular level I'm really quite busy.

Reply to this topic