Re: Add New User

Ok thank you, I think I have it now. Now to get my Client application working. On Nov 6, 2005, at 1:16 PM, Björn Persson wrote: söndagen den 6 november 2005 18:39 skrev Bruce Martin: However, even though I specified 'test.*' my test user can access the mysql database. That's because this s

Re: Add New User

söndagen den 6 november 2005 18:39 skrev Bruce Martin: > However, even though I specified 'test.*' my test user can access the > mysql database. That's because this statement: > UPDATE user SET > Select_priv='Y',Insert_priv='Y',Update_priv='Y',Delete_priv='Y',Create_p > riv='Y' WHERE user.User='t

Re: Add New User

Ok thank you for your replies. I finally got it working, but as you stated I granted too many permissions. I found that in the user table my testUser had N for every column with the exception of the last few which where 0. I first logged into the database using: shell>mysql -u root -p mysq

RE: Add New User

> -Original Message- > From: Michael Stassen [mailto:[EMAIL PROTECTED] > Sent: zondag 6 november 2005 6:26 > To: Mark > Cc: 'Bruce Martin'; mysql@lists.mysql.com > Subject: Re: Add New User > > > Because, afterwards, you forgot to say: >

Re: Add New User

"Bruce Martin" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > When I log in as root using: > mysql -u root -p mysql > I get the mysql prompt: > mysql> > > I then issue this command or statement: > > mysql>GRANT ALL PRIVILEGES ON *.* TO 'testUser'@'' IDENTIFIED BY > 'some_password'

Re: Add New User

Mark wrote: -Original Message- From: Bruce Martin [mailto:[EMAIL PROTECTED] Sent: zaterdag 5 november 2005 3:58 To: mysql@lists.mysql.com Subject: Add New User When I log in as root using: mysql -u root -p mysql I get the mysql prompt: mysql> I then issue this command or statem

Re: Add New User

Bruce Martin wrote: When I log in as root using: mysql -u root -p mysql I get the mysql prompt: mysql> I then issue this command or statement: mysql>GRANT ALL PRIVILEGES ON *.* TO 'testUser'@'' IDENTIFIED BY 'some_password' WITH GRANT OPTION; First, your hostname is blank. That won't work.

RE: Add New User

> -Original Message- > From: Bruce Martin [mailto:[EMAIL PROTECTED] > Sent: zaterdag 5 november 2005 3:58 > To: mysql@lists.mysql.com > Subject: Add New User > > When I log in as root using: mysql -u root -p mysql I get the > mysql prompt: > mysql> &g

Add New User

When I log in as root using: mysql -u root -p mysql I get the mysql prompt: mysql> I then issue this command or statement: mysql>GRANT ALL PRIVILEGES ON *.* TO 'testUser'@'' IDENTIFIED BY 'some_password' WITH GRANT OPTION; I get the following returned: Query OK, 0 rows affected (0.00 sec)

Re: Cannot add new user to newly created database, help needed

Cool!. That solved my problem; I don't understand why doing a grant all didn't fix the permissions but here is my ant output now: [EMAIL PROTECTED] cvebrowser]$ ant test Buildfile: build.xml init: build: jar: test: [echo] Testing using the following classpath: /usr/share/java/junit.jar:te

Re: Cannot add new user to newly created database, help needed

mysql> use mysql; mysql> update user set grant_priv = 'Y' where user = 'root'; mysql> flush privileges and reconnect to mysql server as root user and retry grant clause. You'll be happy!!! ^^ > Greetings, > > I'm trying to create a database and then adding a > specialized user so it can work wit

Cannot add new user to newly created database, help needed

Greetings, I'm trying to create a database and then adding a specialized user so it can work with it, but so far i got no luck: [EMAIL PROTECTED] josevnz]$ mysql -u root -p -h localhost.localdomain Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id