Re: Manually enabling root access from remote machine
sorry if it's a stupid question, but just to cover the basics, you remembered to flush privileges after adding it right? -- James On Jul 11, 2006, at 9:31 AM, John Doolan wrote: Hi, I have just installed mySQL version 5 and want to enable root access from remote machines. However, the configuration tool fails when trying to change the security settings with an error 2003. Apart from this it is working fine (alongside a version 4 server on the same machine). How do I manually enable root access from remote machines as adding "%" into the list of hosts for root does not seem to do anything in Administrator? Regards, John Doolan ** ** * This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender by e-mail or telephone and then delete the e-mail from your system. The sender does not accept liability for any errors or transmissions in the contents of this message. Furthermore, the sender accepts no responsibility for any loss or damage resulting directly or indirectly from the use of this e-mail or the contents. ** ** * Proprietors: Humber-Thames Marketing Ltd. Reg Company No. 1803671 - Established 1983. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: intended behavior of host %
Never mind. I'll just go RTFM and quit bugging you guys on list with stuff answered plain as day in http://dev.mysql.com/doc/refman/5.1/en/adding-users.html Sorry. I'll go caffeinate myself before asking more stupid questions. -- James On Jun 14, 2006, at 11:55 AM, James Barros wrote: Hey guys, I'm running mysql 5.1.9 and I've got a user who's mysql.user host is set to "%" and can log in from any domain except localhost. if I change to localhost, and flush privileges they can log in. Is this intended behavior, or should % be inclusive of localhost? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
intended behavior of host %
Hey guys, I'm running mysql 5.1.9 and I've got a user who's mysql.user host is set to "%" and can log in from any domain except localhost. if I change to localhost, and flush privileges they can log in. Is this intended behavior, or should % be inclusive of localhost? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1045 (28000): Access denied for user (Using password: YES) from outside localhost
Can this use log in from localhost successfully?
Try flushing privileges again?
If that failed, I'd drop the user and recreate?
( Theres really not alot to this, sorry I don't have any more ideas :( )
-- James
On Jun 7, 2006, at 1:07 PM, Aron Levy wrote:
Hi James i follow your recomendation and verify that the hash
produced matches the password field in user exactly.
-- Aron L.
James Barros wrote:
Well, for starters don't worry about ports being open. If you
werent able to connect, it would give you a different error message.
select password('yourpassword'); and verify that the hash
produced matches the password field in user exactly.
-- James
On Jun 7, 2006, at 11:48 AM, Aron Levy wrote:
Hi good afternoon, i am triying to connect with my company's
mysql server using a client program from shell and I keep
receiving the following answer:
[EMAIL PROTECTED] ~]# mysql -u user1 -p -h serverCompany.com
Enter password:
ERROR 1045 (28000): Access denied for user
'user1'@'200.93.42.209' (using password: YES)
[EMAIL PROTECTED] ~]#
I already checked the user was configured for any host ("%"),
the port 3306 is open (checked with nmap), but i dont know what
i need to do or see other variables. I am 100% sure of the
passwords i am using for this users, and i am attaching some
info about the database.
Thank you in advance,
mysql> select * from user;
+---+--+--+-
+-+-+-+-
+--- +-+---+--
+--- ++-+
++
| Host | User | Password | Select_priv |
Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv
| Reload_priv | Shutdown_priv |Process_priv | File_priv |
Grant_priv | References_priv | Index_priv | Alter_priv |
+---+--+--+-
+-+-+-+-
+--- +-+---+--
+--- ++-+
++
| % | user1 | 5804b8eebr456240 | N |
N| N | N | N |
N | N| N | N|
N | N | N | N |
N |
| % | user4 | 6f37d73jsdred201d | N |
N| N | N | N |
N | N| N | N|
N | N | N | N |
N |
[EMAIL PROTECTED] ~]# nmap -A -T4 my.domain.com
Starting Nmap 4.03 ( http://www.insecure.org/nmap/ ) at
2006-06-07 09:57 VET
Interesting ports on xx.xx.xx.xx:
(The 1653 ports scanned but not shown below are in state: closed)
PORT STATESERVICEVERSION
21/tcp open ftpProFTPD 1.2.10
22/tcp open sshOpenSSH 3.9p1 (protocol 1.99)
25/tcp open smtp netqmail smtpd 1.04
53/tcp open domain
80/tcp open http Apache httpd 2.0.53 ((Fedora))
106/tcp open pop3pw poppassd
110/tcp open pop3 Courier pop3d
111/tcp open rpcbind 2 (rpc #10)
135/tcp filtered msrpc
139/tcp filtered netbios-ssn
143/tcp open imap Courier Imapd (released 2004)
443/tcp open ssl/http Apache httpd 2.0.53 ((Fedora))
445/tcp filtered microsoft-ds
465/tcp open ssl/smtp netqmail smtpd 1.04
593/tcp filtered http-rpc-epmap
993/tcp open ssl/imap Courier Imapd (released 2004)
995/tcp open ssl/pop3 Courier pop3d
1720/tcp filtered H.323/Q.931
3306/tcp open mysql MySQL 4.1.15
/tcp filtered krb524
8443/tcp open http Apache httpd 1.3.33 ((Unix)
mod_ssl/2.8.22 OpenSSL/0.9.7e PHP/5.0.4)
Device type: general purpose
Running: Linux 2.6.X
OS details: Linux 2.6.5 - 2.6.11
Uptime 26.627 days (since Thu May 11 18:56:31 2006)
Service Info: OS: Unix
Nmap finished: 1 IP address (1 host up) scanned in 63.549 seconds
mysql
MySQL Support
Active Persistent Links
Active Links
Client API version 4.1.15
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1045 (28000): Access denied for user (Using password: YES) from outside localhost
Well, for starters don't worry about ports being open. If you werent
able to connect, it would give you a different error message.
select password('yourpassword'); and verify that the hash produced
matches the password field in user exactly.
-- James
On Jun 7, 2006, at 11:48 AM, Aron Levy wrote:
Hi good afternoon, i am triying to connect with my company's mysql
server using a client program from shell and I keep receiving the
following answer:
[EMAIL PROTECTED] ~]# mysql -u user1 -p -h serverCompany.com
Enter password:
ERROR 1045 (28000): Access denied for user
'user1'@'200.93.42.209' (using password: YES)
[EMAIL PROTECTED] ~]#
I already checked the user was configured for any host ("%"), the
port 3306 is open (checked with nmap), but i dont know what i need
to do or see other variables. I am 100% sure of the passwords i am
using for this users, and i am attaching some info about the database.
Thank you in advance,
mysql> select * from user;
+---+--+--+-
+-+-+-+-+---
+-+---+--+---
++-+++
| Host | User | Password | Select_priv |
Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv |
Reload_priv | Shutdown_priv |Process_priv | File_priv | Grant_priv
| References_priv | Index_priv | Alter_priv |
+---+--+--+-
+-+-+-+-+---
+-+---+--+---
++-+++
| % | user1 | 5804b8eebr456240 | N | N
| N | N | N | N | N
| N | N| N | N |
N | N | N |
| % | user4 | 6f37d73jsdred201d | N | N
| N | N | N | N | N
| N | N| N | N |
N | N | N |
[EMAIL PROTECTED] ~]# nmap -A -T4 my.domain.com
Starting Nmap 4.03 ( http://www.insecure.org/nmap/ ) at 2006-06-07
09:57 VET
Interesting ports on xx.xx.xx.xx:
(The 1653 ports scanned but not shown below are in state: closed)
PORT STATESERVICEVERSION
21/tcp open ftpProFTPD 1.2.10
22/tcp open sshOpenSSH 3.9p1 (protocol 1.99)
25/tcp open smtp netqmail smtpd 1.04
53/tcp open domain
80/tcp open http Apache httpd 2.0.53 ((Fedora))
106/tcp open pop3pw poppassd
110/tcp open pop3 Courier pop3d
111/tcp open rpcbind 2 (rpc #10)
135/tcp filtered msrpc
139/tcp filtered netbios-ssn
143/tcp open imap Courier Imapd (released 2004)
443/tcp open ssl/http Apache httpd 2.0.53 ((Fedora))
445/tcp filtered microsoft-ds
465/tcp open ssl/smtp netqmail smtpd 1.04
593/tcp filtered http-rpc-epmap
993/tcp open ssl/imap Courier Imapd (released 2004)
995/tcp open ssl/pop3 Courier pop3d
1720/tcp filtered H.323/Q.931
3306/tcp open mysql MySQL 4.1.15
/tcp filtered krb524
8443/tcp open http Apache httpd 1.3.33 ((Unix)
mod_ssl/2.8.22 OpenSSL/0.9.7e PHP/5.0.4)
Device type: general purpose
Running: Linux 2.6.X
OS details: Linux 2.6.5 - 2.6.11
Uptime 26.627 days (since Thu May 11 18:56:31 2006)
Service Info: OS: Unix
Nmap finished: 1 IP address (1 host up) scanned in 63.549 seconds
mysql
MySQL Support
Active Persistent Links
Active Links
Client API version 4.1.15
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqldump locks dumping db "mysql" in 5.1.9
Hello, I've got 5.1.9 running on FreeBSD and I'm trying to do some backups, but mysqldump is locking up on me. when I run: mysqldump -uroot --opt mysql (and yes, it's a test box, so there is no root password. I can duplicate this behavior with other accounts with sufficient priv's specifying a password) I get: -- MySQL dump 10.10 -- -- Host: localhostDatabase: mysql -- -- -- Server version 5.1.9-beta /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; and then it just freezes there till I +c out. It should be noted that I can dump all other db's just fine. This version was installed using ports. mysqldump -V returns: mysqldump Ver 10.10 Distrib 5.1.6-alpha, for portbld-freebsd6.1 (i386) which appears to be 0.0.3 versions out of date compared to the server. Was there some change in DB structure that might cause this issue? Other suggestions? Is this a legit bug I should report to the buglist or did I screw something up? Thanks :) -- James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
