Hello,
Sorry for posting this here, but i've posted in MySQL list and no one
answered.
I'm trying to set a password for a user with the command:
mysql> set password for gamito at localhost=password('blabla');
but i always get the error:
ERROR 1133 (42000): Can't find any matching row in the user table
although i'm pretty sure that the user exists.
I'm using MySQL version 4.1.20 from CentOS 4.4
This neves happened to me :(
Any help would be appreciated.
Best Regards,
AR
Use SHOW GRANTS for the list of users... http://dev.mysql.com/doc/refman/5.0/en/show-grants.html On 02/10/06, AR <lists at tuxdoit.com> wrote:> > Hello, > > Sorry for posting this here, but i've posted in MySQL list and no one > answered. > > I'm trying to set a password for a user with the command: > > mysql> set password for gamito at localhost=password('blabla'); > > but i always get the error: > ERROR 1133 (42000): Can't find any matching row in the user table > > although i'm pretty sure that the user exists. > > I'm using MySQL version 4.1.20 from CentOS 4.4 > > This neves happened to me :( > > Any help would be appreciated. > > Best Regards, > AR > _______________________________________________ > CentOS mailing list > CentOS at centos.org > http://lists.centos.org/mailman/listinfo/centos >-------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.centos.org/pipermail/centos/attachments/20061002/9ecd90c0/attachment-0003.html>
are you in the mysql database when you do that command? and does that user actually exist? maybee you need to create the user with: grant select,insert,update,delete,create,index,alter,drop on somedatabase.* to gamito at localhost identified by 'blabla'; Quoting AR <lists at tuxdoit.com>:> Hello, > > Sorry for posting this here, but i've posted in MySQL list and no one > answered. > > I'm trying to set a password for a user with the command: > > mysql> set password for gamito at localhost=password('blabla'); > > but i always get the error: > ERROR 1133 (42000): Can't find any matching row in the user table > > although i'm pretty sure that the user exists. > > I'm using MySQL version 4.1.20 from CentOS 4.4 > > This neves happened to me :( > > Any help would be appreciated. > > Best Regards, > AR > _______________________________________________ > CentOS mailing list > CentOS at centos.org > http://lists.centos.org/mailman/listinfo/centos >Thanks - Nathan - http://www.linuxcare.ca
On Oct 2, 2006, at 12:49 PM, AR wrote:> Hello, > > Sorry for posting this here, but i've posted in MySQL list and no one > answered. > > I'm trying to set a password for a user with the command: > > mysql> set password for gamito at localhost=password('blabla'); > > but i always get the error: > ERROR 1133 (42000): Can't find any matching row in the user table > > although i'm pretty sure that the user exists. > > I'm using MySQL version 4.1.20 from CentOS 4.4 > > This neves happened to me :( > > Any help would be appreciated. > > Best Regards, > ARThe user name and hostname each need to be in quotes mysql> set password for 'gamito'@'localhost' = password('blabla'); Tony Schreiner
> Hello, > > Sorry for posting this here, but i've posted in MySQL list and no one > answered. > > I'm trying to set a password for a user with the command: > > mysql> set password for gamito at localhost=password('blabla'); > > but i always get the error: > ERROR 1133 (42000): Can't find any matching row in the user table > > although i'm pretty sure that the user exists. > > I'm using MySQL version 4.1.20 from CentOS 4.4 > > This neves happened to me :( > > Any help would be appreciated. >Have you tried the following? set password for 'gamito'@'localhost' =password('blabla');> Best Regards, > AR > _______________________________________________ > CentOS mailing list > CentOS at centos.org > http://lists.centos.org/mailman/listinfo/centos >
> mysql> set password for gamito at localhost=password('blabla'); > > but i always get the error: > ERROR 1133 (42000): Can't find any matching row in the user tablemysql> set password for 'bar'@'localhost' = password ('baz'); Query OK, 0 rows affected (0.04 sec) mysql>