MYSQL :: Authentication Problem On Nonstandard Port

Port Range
What range of ports does MySQL use because I need to set it up with my firewall. At the moment i have added 3306 but when it changes port to one in whatever the range is it says lost connection to server. It works fine with firewall off.

Can I Run Two Instances On Same PORT
I am using mysql and like to know the possibilities of running two instances in same port?

What Port Does Mysql Use For SSL?
I can't find it documented what port the mysql server uses to listen for SSL connections. I'm trying to figure out what port to open up in the firewall. I'm using mysql 5.0.24a on RHEL 4.

Port 3306
I'm trying to install my sql on a w2k3 std box....... I get the firewall setting error message... I open up the port (like stated in all the many topics I've seen here.... I STILL get the same massage. What the hell do I do? I tried earlier versions up to ver 4.1 and still the same thing.

Can't Connect Port = 0??
I have root access to this server which has been preconfigured. I can
connect using the mysql command tool. But I cannot connect using any
mysql GUI software (I am currently tunneling the 3306 port to 3306 on
the server using SSH). So i ran mysqladmin variables. And got the
following:

port 0

instead of the usually port 3306. Obviously I cannot connect on port 0.
How can I troubleshoot this and get mysql running so I can connect via
tunneling?

MySQL Port
How do I check that what Port number is MySQL is running on it? I type this command: netstat -a did not show anything yet.
But I know that mysql run 3306 as default number, but when I run the following command: netstat -a | grep 3306 gives the following warning: 'warning, got duplicate tcp line'

Default Port Of Mysql
I've installed mySQL-essential-4.1.22-win32.

And it doens't connected to my coldfusion webserver because of port problem.

What is the default port of mySQL-essential-4.1.22-win32?

On What Port Is MySQL Running?
I'm running MySQL on my Mac, and I'm trying to figure out on what port MySQL is running. What can I type into Unix terminal to figure this out? Or can I find out some other way?

Open Additional Port
I need to access an external MySQL db through a firewall. I'd like to open up an additional port (leaving 3306 as is) to the same MySQL instance.
For example, I have my mail server running on both ports 25 and 26 (ISP blocks outbound 25).

Port 3306 - Can't Get Started
I have tried to install MySQL 4.0.14 on my Pentium 1.7Ghz running WindowsXP
Professional.

the installation ran through without any problems.

However, every command gives an error:
C:mysqlin>mysql
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

C:mysqlin>mysql --install
mysql: ERROR: unknown option '--install'

C:mysqlin>mysqladmin -u root shutdown
....failed - and it suggested I telnet localhost 3306

C:mysqlin>telnet localhost 3306
Connecting to localhost...Could not open connection to the host, on port
3306: Connect failed

C:mysqlin>mysqladmin test
mysqladmin: connect to server at 'localhost' failed.

MySQL Server On Different Port
Because I'm using a Java program that connect to my MySQL server from a remote location that doesn't allow connecting to port 3306.

I'm forced to change the port to a number that will work on the client end. Port 23 is allowed and since I don't run a telnet server, I'd like to run MySQL on port 23 instead of 3306. I change it to port 23 in the my.conf file, but the service won't start. I can make it port 3310 and it'll start just fine. Why won't it let me use 23?

Changing Mysql Port
How do you change the mysql port?

Opening Mysql Port
What I want to do is to open the mysql port. So I can access it from an other computer. How do I do this? I guess it's in an config file, But wich?

MySQL Server Port
whats the name of the config file I can edit so that mysql listens on port 3306. I dont seem to have a *.cnf file that acts as the mysql config file.
Better yet, what tool can I use to determine what config file was used

Changing Mysql Port:
How do you change the mysql port

MySQL Port 3306
I want to run MySQL on server but it only be accessible to programs on
localhost. I see that port 3306 is open on server so I need to close
it.How do I do that while keeping it available to programs running on
localhost?

Authentication
I'm new with mysql and I feel very stupid for having to ask this but I'm trying to program against it and I don't know what my username and pw are. When I installed it, I put in a pw so I'm pretty sure I know what that is, but what is the username I should be using when trying to execute sql commands against it with php?

Authentication
Is there any config file or update to have MySQL use HPUX authentication or NT authentication. for the Windows apps. (Query browser and MySQL Administrator)

Authentication
i want to make a user that can only see one database here with a seperate limited access.

Authentication
I am trying to set the root password, but all I get is:

$ ./mysqladmin -u root password <newpassword>
./mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

I have no problems connecting like this:

./mysql -u mysql

In the latter case, I cannot do anything. For example

mysql> CREATE DATABASE one;
ERROR 1044 (42000): Access denied for user ''0'localhost' to database 'MoonlightDB'

Ado Connection String For Tcpip Port
Currently I connect to MySql using the following vbscript:

set conn = createobject("ADODB.Connection")
conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};"_
& "SERVER=localhost;"_
& "DATABASE=test;"_
& "UID=venu;PWD=venu;OPTION=3"
conn.open()

I would like to change my connection string so that I connect using
TCP/IP and I would like to specify port 3306 inside the string. I
know how to do this with MS SqlServer, but does someone know how to do
this with MySQL?

MySQL Multiple Port Numbers
Have a LAMP server and am trying to get MySQL to listen on multiple ports.. I need 3306 and 3307 and I just can't figure out how to get it to listen on both, one or the other just not both at the same time.

MySQL 4.0.1 Port 3306 Error
I am trying to run the server on my PC and have already got Apache and PHP working fine. Whenever I run MySQL 4.0.1 Gamma however, a port 3306 error comes up saying that I possibly have another copy of the MySQL server already running which is not true. Also, I have noticed that my internet connection ceases to function along with Apache and everything tells me I'm behind an unknown proxy server.

Cannot Remote Access On Non-default Port
On MySQL server running on UNIX machine I changed the default port 3306 to 40006. From Windows PC I ran this command: mysql -p -u user1 -h mysqltest:40006 testdatabase

It does not work. It only works if I use the default port 3306.
How can I remote access on non-default port?

How To Change Root Password And Port
I have recently installed MySQL 3.23 on Windows 2000 Server. Can anyone tell me how do I change the root password and default port of MySQL?

Access Denied With Port 3306
here is my problem

I get the error "access denied for user root@localhost" with a note that if I have a firewall I should open port 3306

I really have a Norton 2005 firewall enabled and I do not know how to open port 3306
although I give a rule to all mysql services to use any ports.

Slow Authentication
MySQL V 5.0.18 on SUSE 10.1

I'm not a complete *nix noob, but I sure as hell ain't a *nix or MySQL pro.

This is a new installation. Everything screaming fast. Unless it deals w/authentication.

Try to get in w/SQLyog from W2K locally ... intitial connection takes ~20 seconds. Then everything screaming fast.

Web Server (W03) attempts to connect via MyODBC ... same result ... initial connection takes ~20 seconds. Subsequent queries screaming fast.

VNC into the box at any time ... everything fast. (would seem to eliminate network/connection issues)

Authentication To MySQL
i have one problem with l'authentication to the MySQL;
I am using the language Java and i access to the data-base in following

db = DriverManager.getConnection("jdbc:mysql://localhost:3306/" +
nomeDB + "?user=" + nomeUtente + "&password=" + pwdUtente);

but I do not want insert pwdUtente and nomeUtente in the source-code,
What can i do?

Encryption / Authentication
I need to find out if it's possible to do two things with mysql. The =
first is external authentication, preferably with kerberos5, but PAM =
will work as well. Second, encrypting the data stream. Specifically =
with jdbc connections.

User Authentication
I do know how to create user logins and such.what I need to know is once a user logs in and submits his data (CSV) to Mysql DB,how do i ensure that the data goes into his account.In other words,whats the best way to manage user accounts and control the data that goes into that.

Windows Authentication
I would like to a Windows Authentication with MySQL (similar to the Windows Authentication available for SQL Server).

Does anyone knows how it can be done?

Authentication Protocol
I am trying to run an application using MySQL as a DB, but i am receiving the following error message:
"Client does not support authentication protocol requested by server; consider upgrading MySQL client"
I am using MySQL Client Version 5.0.11
Could someone tell how can I fix this issue.

MySQL And PHP Authentication
I'm getting the following error while trying to connect via php to an existant mysql (local) server:

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client.
I have latest PHP and MySQL installed.

This seems like the password problem (new password system now) the older was 16 bits right? Thing is... My PHP should support this, its 5.x and I have latest mysql as well.

Authentication Protocol
You have no license for using PerlDesk! DBI connect('perldb:localhost','webuser',...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at lib/PerlDesk/App.pm line 408 Compilation failed in require at lib/PerlDesk/App/License.pm line 3. BEGIN failed--compilation aborted at lib/PerlDesk/App/License.pm line 3. Compilation failed in require at lib/PerlDesk/App/Installer.pm line 9. Compilation failed in require at C:/Program Files/Apache Group/Apache2/cgi-bin/install.cgi line 25.

Windows Authentication
Can MySQL use windows authentication?
If so, what are the changes to the connection string for this?

Authentication Protocol
I am running winXP, mysql, vb 6.0/vbscript.
when i connect through odbc it gave me the following error.
Run-time error'-2147467259 (800004005)
[MySQL][ODBC 3.51 Driver] Client does not support authentication protocol requested by server; consider upgrading MySQL Client

When i connect this mysql with vb 6.0/vbscript in windows 98 it runs perfectly.

Passwords / Authentication
I have just started messing around with MySQL and something I find weird is that we connecting using localhost, if I supply the password, it will not authenticate...if I leave the password off, it's fine.If I connect from another machine, it requires the password or it will not authenticate.Is that normal?

Authentication Protocol
I recently had a crash with MySQL-Max 4.0.5beta in the Windows 2000 Server inviroment. I uninstalled it completely and salvaged the DATA directories. So i decided to go ahead and upgrade the MySQL to Server 4.1.7. But now I get an error message from all my scripts that tell me the following.
Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL
Can some one please assist me in fixing this matter. I am very limited in MySQL and have done hours of research trying to fix this matter.

Support Authentication
i have installed php4.4 with iis and mysql5 and phpmyadmin is 2.5 version and mysql administration tool too i get the error client does not support authentication protocol,
i will be very pleased if someone suggest a good workin version for all mysql php and phpmyadmin

Authentication Protocol
I am having trouble with my MySQL database, so when I run a script I receive the following error:
'Warning: mysql_pconnect() [function.mysql-pconnect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in c:wwwdcdjpaneldatabasedb.php on line 27
Client does not support authentication protocol requested by server; consider upgrading MySQL client'
I understand that it has something to do with old db access libraries. I really don't understand the instructions to be done, so if I could be provided with a full-detail list of instructions on fixing this error, I'd appreciate it.
By-the-way, I looked into the documentation of the MySQL software and looked at the website for support, which was a little pricy for one needed solution.

Authentication Protocol
A problem with MYSQL Front 3.1 that will not connect.
I understand that there is a problem with MySQL changing the password hasing functions in ver 4.
One solution is to start the server with the --old-passwords flag, how do i add the flag??

How To Shutdown MySQL Default Port (3306)
i am Using Mysql default port 3306 I have created database and now I want to shut the port so i can used my other application of Instant Rails which uses Mysql to run that port. Can you plz jus help me how to shutdown the default port so i can use another application.

Mysql Commandline Tool -- Port Broken
the "mysql" command allows me to use any ridiculous number after "--port=", even "80", as shown below. I can even use a random string like "abcd" in place of "80".

Exactly what I want to do? I need to experiment with the "mysql" commandline tool together with tcpdump. So far, my tcpdump command cannot detect *any* thing about mysql.

yes my tcpdump can detect http traffic.
yes my tcpdump can detect something when i run "telnet loalhost 3306".

------------- snip ---------------
$ mysql -u xxx -pxxxxxx -h localhost --port=80 -vvv
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 8319 to server version: 3.23.58

Reading history-file /home/httpd/vhosts/portal.crpp.servy.net/.mysql_history
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

Connector/ODBC Not Saving Port Setting
Using MySQL Connector/ODBC 3.51, I set the port to a non-default value
(3309), under 'Connection Options' to connect to a remote machine running 2
versions of MySQL. 'Test' is successful but when I close the Connector/ODBC
window on XP the port setting is not saved so the DSN doesn't work.

Close Mysql Port Or Bind It To Only Localhost Or ...
I only use mysql locally. I want to

- close port 3306 if possible (like starting Oracle database without
starting listener),
- or bind it to localhost only (like what sendmail does),
- or next best thing

for security.

I am on redhat 9, and use mysql 3.23.55. I can upgrade if newer
version provide the functionality.

Internet Port 3306 Open Safe
I have a server at an ISP - I've got port 3306 open in the firewall so
that I can work from remote however its got me thinking if its safe? I
know Microsoft got hit with slammer (or whatever) worm on their
unpatched machines that were exposed to the outside world, but I'm
trying to measure up the risks by having my db server exposed for a few
weeks.

Best Approach To User Authentication?
So I'm setting up a php/mysql driven website on our company's intranet. I need to setup username's and passwords for different individuals because they all need access to different parts of the site.

Now I'm reading up on how to do user authentication. One way I am reading about, involves creating a username/password table in the database, and when the user attempts to login in some generic php/html form, the php logs into the database using a generic login/password, then checks to see if the user's login/password match up with what is in the table.

That's an interesting way to do it. But the thing that is odd to me is that you actually log into the database using a generic login/password (hidden in the php script) and you would simply have to control what the user has access to in your frontend code, based off their login.

MySQL has it's own user authentication system in place, where you create logins and passwords for the database and control what databases and tables they have access to and control what they can do with them. So why wouldn't you do it this way?

Sorry if this sounds confusing, but hopefully users experienced in this understand where I am coming from.

Authentication / Permission Basics
I have a number of users like 'fred', who can access MySQL 4.1 from %.fredworld.com. He has full access to his own database, fred. No other permissions defined.

What's the best way for me to allow every user to connect from localhost. After reading up on http://dev.mysql.com/doc/refman/4.1/en/connection-access.html I thought the answer might be to do:

insert into user (host, user) values ('localhost', '');
flush privileges;

but this doesn't do what I want. How should I go about this?