MySQL "access denied" problems using port forwarding and MySQL Administrator

MySQL "access denied" problems using port forwarding and MySQL Administrator

Post by Ethan » Sun, 27 Jun 2004 06:54:34


Like it says, I'm trying to use MySQL Administrator over an ssh-forwarded
connection, using port 3306. I tell MA to connect to localhost:3306 as root,
including the password, and it gives me the old " XXXX@XXXXX.COM "
denied crap. I've added root users for %, localhost, localhost.localdomain,
and the name of the machine from which I'm connecting, all of which seem to
do me zero good. Why the heck is mysql so difficult about permissions and
the hosts from which users come?

--
eth'nT
 
 
 

1. [Announce] DataDirect XQuery 3.1 Supports MySQL; Access MySQL Tables as XML using XQuery

2. Problem getting PHP to recognize MySQL, Using PHP 4.3.7 and MySQL 4.0.20

Hi there!

I have both PHP 4.0( RPM) installed and MySQL 4.0.20 installed with the
mysqld daemon up and running. But when I look at the output of phpinfo() ,
I do not see it there, which is worrisome and so I tried to recompile PHP
and do ./configure with the --with-mysql=path but I don't really know
where my mysql's header files should be , is there any way to find that
out by using any of the mysql commands?

I did try to do ./configure for PHP4 without any parameters and when I
looked at the output, I do see that PHP seems to recognize that mySQL is
there :

...
checking for MSSQL support via FreeTDS... no
checking for MySQL support... yes
checking for specified location of the MySQL UNIX socket... no
checking for MySQL UNIX socket location... /var/lib/mysql/mysql.sock
checking for inline... (cached) inline
....

Hence, why is that when I do phpinfo() , mySQL still doesn't show up?

I suspect that mysql isn't working correctly with php, because if I use
the mysql_connect() function in my php, I get the error "Fatal error: Call
to undefined function: mysql_connect() "
and yet it DOES seem like PHP recognizes mysql is there.

That "unable to recognize mysql_connect function" error comes up after
installing PHP using ./configure with or without any parameters.

Please help, thanks. I am pretty sure my MySQL is properly installed
because I can mysql into the server and set up my database

##-----------------------------------------------#
Article posted from PHP Freaks NewsGroup
http://www.yqcomputer.com/
Get *** ed: alt.ph
##-----------------------------------------------##

3. Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) LEOPARD

4. Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) LEOPARD

5. ERROR#: 2002 can't connect to MySQL server through socket '/var/mysql/mysql.sock'

6. Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) LEOPARD

7. mailing.database.mysql-internals, mailing.database.mysql, mailing.database.mysql-java, comp.lang.java.programmer

8. ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

9. Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) LEOPARD

10. Is there anyway to access MySQL database using ODBC without opening port 3306?

11. MYSQL: mysql client/grant IP access

12. [PHP] Limiting connection to mysql using old mysql module (not mysqli)

13. Using Python and Connecting to MySQL remotely WITHOUT MySQL installed on local computer