Authentication Problem On Nonstandard Port
I am running two database instances of mysql (one on a nonstandard
port). After granting users permissions I find that I can access
mysql from other machines only if I use the standard port. When I use
the non-standard port I can only authenticate if I am on the box where
the database is running. Also some previously set up users can
authenticate through the non-standard port (sadly no one knows how
those users were set up). What do I need to do to allow for
authentication on the nonstandard port ex:
mysql -h<HOST> -u<USERNAME> -p
(defaulting to standard port works)
mysql -h<HOST> -u<USERNAME> -P<NON-STANDARD PORT> -p
(fails)
View Complete Forum Thread with Replies
Related Forum Messages:
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?
View Replies !
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'
View Replies !
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.
View Replies !
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.
View Replies !
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?
View Replies !
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?
View Replies !
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.
View Replies !
Installation :: Port 8080
I have php and apache set up on my desktop , for my testing server. since port 80 was not accessible, I had to configure my apache server to use port 8080. i have tested these settings and both apache and PHP are working fine. the problem starts with mysql. i have installed mysql to the default C:MySQL . i can not start mysql.i always get the error "cannot connect to localhost (10061)" . i searched for solutions to this error, but most solutions on the forum didnt work for my particular problem. would this have anything to do with my localhost being localhost:8080, instead of the default localhost on port 80. is there any way of pointing mysql to localhost:8080
View Replies !
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
View Replies !
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?
View Replies !
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).
View Replies !
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?
View Replies !
Port Information Issue!
Glad to join the forums! I have a linux php apache box which connects to a mysql server on a windows 2003 box. I am working towards securing the mysql database and when I run nmap on the windows box the following port is open which is the mysql port (3306) but also shows the following information. 3306/tcp open mysql MySQL 5.0.67-community-nt | MySQL Server Information: Protocol: 10 | Version: 5.0.67-community-nt | Thread ID: 16 | Some Capabilities: Connect with DB, Compress, Transactions, Secure Connection | Status: Autocommit |_ Salt: ?o6]Sd!r?#1jDST-#eUZ Is there any way for me change the information displayed ? Or remove it for securing the server?
View Replies !
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?
View Replies !
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?
View Replies !
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?
View Replies !
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.
View Replies !
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.
View Replies !
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
View Replies !
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.
View Replies !
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?
View Replies !
How To Log Authentication Failures ONLY?
I am trying to figure out how I can log _only_ authentication failures with mysql. It appears to me, that I can only either log all queries and mysqld errors, or only mysqld errors? I have tried in my.cnf: [mysqld] log = /var/log/mysql/access.log log_error = /var/log/mysql/error.log log_warnings = 1 But this logs every single query made, which I don't want, as it fills up the log files too much. If I do only [mysqld] log_error = /var/log/mysql/error.log log_warnings = 1 or... [mysqld] log_error = /var/log/mysql/error.log log_warnings = 2 ... then I get only mysqld errors, but nothing related to authentication failures. Is there a way to configure this?
View Replies !
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?
View Replies !
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)
View Replies !
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?
View Replies !
Change Port :: Configuration File?
i downloaded the zip file for mySQL and unpacked it to a directory then when i run the "mysql.exe" file from the bin directory i get the following error... ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061) may be this is because i'm running IIS on my PC. on localhost.... how can i change the port for mysql... where is the configuration file?
View Replies !
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.
View Replies !
Port 3306 Unless Standard Configuration
I've been trying figure out this problem for a while. Port 3306 won't forward unless I have standard configuration server installed when I'm trying to make a Detailed Configuration. That means port 3306 only opens up (yes I port forwarded and my ISP does not block 3306) when Standard Configuration is choosen.
View Replies !
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.
View Replies !
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.
View Replies !
3306 Port Information Issue..
working towards securing the mysql database and when I run nmap on the windows box the following port is open which is the mysql port (3306) but also shows the following information. 3306/tcp open mysql MySQL 5.0.67-community-nt | MySQL Server Information: Protocol: 10 | Version: 5.0.67-community-nt | Thread ID: 16 | Some Capabilities: Connect with DB, Compress, Transactions, Secure Connection | Status: Autocommit |_ Salt: ?o6]Sd!r?#1jDST-#eUZ Is there any way for me change the information displayed ? Or remove it for securing the server?
View Replies !
Support Authentication Protocol
I have a service provider where my mySQL database is being held. Everything is uploaded and ready to go. When i try to access the database via my ASP code i get the following error message: Client does not support authentication protocol requested by server; consider upgrading MySQL client I've heard to use the Password/ Old password functions, but who has to do that, me or the service provider? When i try to use the Command prompt from the MySQL administrator it won't let me access the command prompt.
View Replies !
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?
View Replies !
Client Does Not Support Authentication
The problem is that when i browse to http://reception/admin/index.php? and enter username and password I recieve the following message 1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client But i can log into mysql using the command prompt
View Replies !
MySql / Php Authentication Problems
whenever I try to access mySql, I alway's get the following error: #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client A little extra info (if needed): -I just installed php v 4.3.1, apache 2, and mySQL 4.1 -It's all on my laptop (if it makes a diffrence) -It's on a windows platform
View Replies !
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.
View Replies !
Installing Mysql :: Cannot Connect To Localhost Port...
I have tried to install mysql 4.0.14 and previous version on my machine. After installation when I try to run mysql, i get error: "Cannot connect to localhost port..." my machine is not connected to internet. I also have firewall installed on my machine. why I may be getting this error.
View Replies !
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.
View Replies !
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.
View Replies !
How To Determine Which Port MySQL Is Running On (LocalHost)?
I tried running "mysqladmin variables -u root -p" and seeing what it lists, the only things that seemed relevant are: | hostname | MyComputer (valid machine name) | named_pipe | ON | port | 0 | report_port | 3306 | report_user | Is there anything else I should get? Is there anyway to confirm which MY.INI it is loading? Why is PORT 0? And what is REPORT_PORT? When I start the MySQL database and check the DataMachineName.err file I see the following: 090327 22:06:45 InnoDB: Started; log sequence number 0 46409 090327 22:06:45 [Note] Event Scheduler: Loaded 0 events 090327 22:06:45 [Note] H:DevelMySQLMySQL Server 5.1inmysqld: ready for connections. Version: '5.1.32-community' socket: '' port: 0 MySQL Community Server (GPL) I assume this means it is running on PORT 0? How does that make any sense? Some of the things I've already tired (maybe it will help you guys figure out what my next step should be): C:>telnet localhost 3306 Connecting To localhost...Could not open connection to the host, on port 3306: Connect failed C:>telnet localhost 0 Connecting To localhost...Could not open connection to the host, on port 0: Connect failed MySQL runs fine from the command line And the User is "root" with password "pass" Service is running (started it manually - and console application works) mysqladmin.exe -u root -p ping Enter password: ** mysqld is alive I added BINMySQLd.exe to the firewall options @ opened port 3306 on the Firewall - didn't touch my router (using localhost - I imagine I don't need to go that far). Running it in PHP5 always gives me the following error: $this->connection_id = @mysql_connect('localhost', 'root', 'pass'); >> Can't connect to MySQL server on 'localhost' (10061)
View Replies !
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.
View Replies !
|
TRACKER
