Problem creating new user.
Hi,
I can create new user with following.
mysqlINSERT INTO user (Host,User,Password)
VALUES('localhost','ads11',PASSWORD('ads11'));
mysqlINSERT INTO db (Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv,
Create_priv,Drop_priv) VALUES
('localhost','bankaccount','ads11','Y','Y','Y','Y','Y','Y');
mysql FLUSH PRIVILEGES;
But when I use Host 'www.allnet.com' in place of 'localhost' in both above mentioned
INSERT command It enters values in to table but when I try to access database by
mysqlmysql -u ads11 -p bankaccount
mysql (Here I enter password 'ads11')
It gives following error :[EMAIL PROTECTED] root]# mysql -u ads11 -p bankaccount
Enter password: (here I enter password 'ads11')
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
Domain www.allnet.com is registered, having live IP on which web server is running
succefully.
Any clue about problem.
Thanks
-
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
Re: Problem creating new user.
Unless i'm misunderstanding(highly possible)...if you are on the command
line, you are going to be seen by mysql as localhost and not allnet.com.
You'll only be seen as another host if you connect remotely. the webserver
running on the localmachine and the mysql client will be seen as localhost.
hth
Jeff
ads mysql
[EMAIL PROTECTED]To: [EMAIL PROTECTED]
om cc:
Subject: Problem creating new user.
12/17/2003 07:45
AM
Hi,
I can create new user with following.
mysqlINSERT INTO user (Host,User,Password)
VALUES('localhost','ads11',PASSWORD('ads11'));
mysqlINSERT INTO db
(Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv,
Create_priv,Drop_priv) VALUES
('localhost','bankaccount','ads11','Y','Y','Y','Y','Y','Y');
mysql FLUSH PRIVILEGES;
But when I use Host 'www.allnet.com' in place of 'localhost' in both above
mentioned INSERT command It enters values in to table but when I try to
access database by
mysqlmysql -u ads11 -p bankaccount
mysql (Here I enter password 'ads11')
It gives following error :[EMAIL PROTECTED] root]# mysql -u ads11 -p bankaccount
Enter password: (here I enter password 'ads11')
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
Domain www.allnet.com is registered, having live IP on which web server is
running succefully.
Any clue about problem.
Thanks
-
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem creating new user.
On Wednesday 17 December 2003 12:45, ads mysql wrote: It gives following error :[EMAIL PROTECTED] root]# mysql -u ads11 -p bankaccount Enter password: (here I enter password 'ads11') ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Domain www.allnet.com is registered, having live IP on which web server is Your mysql command line statement provides no host to connect to, so it uses the local socket to communicate. Mysql sees this as 'localhost'. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem creating new user.
I tried to connect as follows : # [EMAIL PROTECTED] root]# mysql -h www.allnet.com -u ads11 bankaccount ERROR 1130: Host 'xxx-xx-xxx-xxx.yyy.com' is not allowed to connect to this MySQL server # It gives error. I sthere anything giving permission to connect to mysql for particular Host? Thanks for support. Duncan Hill [EMAIL PROTECTED] wrote: On Wednesday 17 December 2003 12:45, ads mysql wrote: It gives following error :[EMAIL PROTECTED] root]# mysql -u ads11 -p bankaccount Enter password: (here I enter password 'ads11') ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Domain www.allnet.com is registered, having live IP on which web server is Your mysql command line statement provides no host to connect to, so it uses the local socket to communicate. Mysql sees this as 'localhost'. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] - Do you Yahoo!? Free Pop-Up Blocker - Get it now
Re: Problem creating new user.
ads mysql wrote: I tried to connect as follows : # [EMAIL PROTECTED] root]# mysql -h www.allnet.com -u ads11 bankaccount ERROR 1130: Host 'xxx-xx-xxx-xxx.yyy.com' is not allowed to connect to this MySQL server # Your DNS is broken. It gives error. I sthere anything giving permission to connect to mysql for particular Host? Use GRANT unless you know what you are doing. Thanks for support. Duncan Hill [EMAIL PROTECTED] wrote: On Wednesday 17 December 2003 12:45, ads mysql wrote: It gives following error :[EMAIL PROTECTED] root]# mysql -u ads11 -p bankaccount Enter password: (here I enter password 'ads11') ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Domain www.allnet.com is registered, having live IP on which web server is Your mysql command line statement provides no host to connect to, so it uses the local socket to communicate. Mysql sees this as 'localhost'. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] - Do you Yahoo!? Free Pop-Up Blocker - Get it now -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem creating new user.
Hi, I tried to create user with GRANt as follows : mysql use mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON bankaccount.* TO ads123@'www.networkshastrihall.com' IDENTIFIED BY 'ads123'; Query OK, 0 rows affected (0.00 sec) mysql FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) I think this is not entering into table. [EMAIL PROTECTED] root]# mysql -h www.networkshastrihall.com -u ads123 -p bankaccount Enter password: ERROR 1130: Host '202-63-167-192.exatt.com' is not allowed to connect to this MySQL server. DNS www.networkshastrihall.com is working. Help appreciated. Thanks gerald_clark [EMAIL PROTECTED] wrote: ads mysql wrote: I tried to connect as follows : # [EMAIL PROTECTED] root]# mysql -h www.allnet.com -u ads11 bankaccount ERROR 1130: Host 'xxx-xx-xxx-xxx.yyy.com' is not allowed to connect to this MySQL server # Your DNS is broken. It gives error. I sthere anything giving permission to connect to mysql for particular Host? Use GRANT unless you know what you are doing. Thanks for support. Duncan Hill wrote: On Wednesday 17 December 2003 12:45, ads mysql wrote: It gives following error :[EMAIL PROTECTED] root]# mysql -u ads11 -p bankaccount Enter password: (here I enter password 'ads11') ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Domain www.allnet.com is registered, having live IP on which web server is Your mysql command line statement provides no host to connect to, so it uses the local socket to communicate. Mysql sees this as 'localhost'. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] - Do you Yahoo!? Free Pop-Up Blocker - Get it now -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing
Re: Problem creating new user.
If that error is verbatim from the console, then DNS may be working, but it is not who MySQL is acknowledging you as, is there a firewall in between you and the MySQL server? looks like you'd need a grant for 202-63-167-192.exatt.com. and i know its not working, but you really shouldn't post passwords to this list. all posts are archived and that means your password can be read by anyone who google's for help or searches the mysql archive. hth Jeff ads mysql [EMAIL PROTECTED]To: gerald_clark [EMAIL PROTECTED] om cc: [EMAIL PROTECTED] Subject: Re: Problem creating new user. 12/17/2003 10:44 AM Hi, I tried to create user with GRANt as follows : mysql use mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON bankaccount.* TO ads123@'www.networkshastrihall.com' IDENTIFIED BY 'ads123'; Query OK, 0 rows affected (0.00 sec) mysql FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) I think this is not entering into table. [EMAIL PROTECTED] root]# mysql -h www.networkshastrihall.com -u ads123 -p bankaccount Enter password: ERROR 1130: Host '202-63-167-192.exatt.com' is not allowed to connect to this MySQL server. DNS www.networkshastrihall.com is working. Help appreciated. Thanks gerald_clark [EMAIL PROTECTED] wrote: ads mysql wrote: I tried to connect as follows : # [EMAIL PROTECTED] root]# mysql -h www.allnet.com -u ads11 bankaccount ERROR 1130: Host 'xxx-xx-xxx-xxx.yyy.com' is not allowed to connect to this MySQL server # Your DNS is broken. It gives error. I sthere anything giving permission to connect to mysql for particular Host? Use GRANT unless you know what you are doing. Thanks for support. Duncan Hill wrote: On Wednesday 17 December 2003 12:45, ads mysql wrote: It gives following error :[EMAIL PROTECTED] root]# mysql -u ads11 -p bankaccount Enter password: (here I enter password 'ads11') ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Domain www.allnet.com is registered, having live IP on which web server is Your mysql command line statement provides no host to connect to, so it uses the local socket to communicate. Mysql sees this as 'localhost'. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] - Do you Yahoo!? Free Pop-Up Blocker - Get it now -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Problem creating new user.
MySQL checks the IP address of the user connecting to it's server. It then does a Reverse DNS lookup on that IP address, to get the name associated with it (there is only one name associated with any IP, the rest are just aliases) The host you are connecting from does not resolve to www.networkshastrihall.com , it resolves to 202-63-167-192.exatt.com . You would need to be connecting to MySQL from the computer www.networkshastrihall.com sits on to be able to connect. Chris -Original Message- From: ads mysql [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 17, 2003 7:44 AM To: gerald_clark Cc: [EMAIL PROTECTED] Subject: Re: Problem creating new user. Hi, I tried to create user with GRANt as follows : mysql use mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON bankaccount.* TO ads123@'www.networkshastrihall.com' IDENTIFIED BY 'ads123'; Query OK, 0 rows affected (0.00 sec) mysql FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) I think this is not entering into table. [EMAIL PROTECTED] root]# mysql -h www.networkshastrihall.com -u ads123 -p bankaccount Enter password: ERROR 1130: Host '202-63-167-192.exatt.com' is not allowed to connect to this MySQL server. DNS www.networkshastrihall.com is working. Help appreciated. Thanks gerald_clark [EMAIL PROTECTED] wrote: ads mysql wrote: I tried to connect as follows : # [EMAIL PROTECTED] root]# mysql -h www.allnet.com -u ads11 bankaccount ERROR 1130: Host 'xxx-xx-xxx-xxx.yyy.com' is not allowed to connect to this MySQL server # Your DNS is broken. It gives error. I sthere anything giving permission to connect to mysql for particular Host? Use GRANT unless you know what you are doing. Thanks for support. Duncan Hill wrote: On Wednesday 17 December 2003 12:45, ads mysql wrote: It gives following error :[EMAIL PROTECTED] root]# mysql -u ads11 -p bankaccount Enter password: (here I enter password 'ads11') ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Domain www.allnet.com is registered, having live IP on which web server is Your mysql command line statement provides no host to connect to, so it uses the local socket to communicate. Mysql sees this as 'localhost'. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] - Do you Yahoo!? Free Pop-Up Blocker - Get it now -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem creating new user.
As advised by other member of this mailing list, Let me check whether it is reverse DNS problem. Reverse DNS is giving 202-63-167-192.exatt.com instead www.networkshastrihall.com. Regarding password, this is test database not in production . I am going to change all settings later on. From next time I will keep in mind. Thanks for support. [EMAIL PROTECTED] wrote: If that error is verbatim from the console, then DNS may be working, but it is not who MySQL is acknowledging you as, is there a firewall in between you and the MySQL server? looks like you'd need a grant for 202-63-167-192.exatt.com. and i know its not working, but you really shouldn't post passwords to this list. all posts are archived and that means your password can be read by anyone who google's for help or searches the mysql archive. hth Jeff ads mysql om cc: [EMAIL PROTECTED] Subject: Re: Problem creating new user. 12/17/2003 10:44 AM Hi, I tried to create user with GRANt as follows : mysql use mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON bankaccount.* TO ads123@'www.networkshastrihall.com' IDENTIFIED BY 'ads123'; Query OK, 0 rows affected (0.00 sec) mysql FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) I think this is not entering into table. [EMAIL PROTECTED] root]# mysql -h www.networkshastrihall.com -u ads123 -p bankaccount Enter password: ERROR 1130: Host '202-63-167-192.exatt.com' is not allowed to connect to this MySQL server. DNS www.networkshastrihall.com is working. Help appreciated. Thanks gerald_clark wrote: ads mysql wrote: I tried to connect as follows : # [EMAIL PROTECTED] root]# mysql -h www.allnet.com -u ads11 bankaccount ERROR 1130: Host 'xxx-xx-xxx-xxx.yyy.com' is not allowed to connect to this MySQL server # Your DNS is broken. It gives error. I sthere anything giving permission to connect to mysql for particular Host? Use GRANT unless you know what you are doing. Thanks for support. Duncan Hill wrote: On Wednesday 17 December 2003 12:45, ads mysql wrote: It gives following error :[EMAIL PROTECTED] root]# mysql -u ads11 -p bankaccount Enter password: (here I enter password 'ads11') ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Domain www.allnet.com is registered, having live IP on which web server is Your mysql command line statement provides no host to connect to, so it uses the local socket to communicate. Mysql sees this as 'localhost'. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] - Do you Yahoo!? Free Pop-Up Blocker - Get it now -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing
