After I uninstalled 4.1 I removed the /var/db/mysql/ directory so that the
install of 4.0.6 would start fresh and create its defualt users and
databases with no trace of the previous user entries.
Schrodinger wrote:
I have removed all localhost user entries and all users should now be
able
[snip]
After I uninstalled 4.1 I removed the /var/db/mysql/ directory so that
the
install of 4.0.6 would start fresh and create its defualt users and
databases with no trace of the previous user entries.
[/snip]
Are you doing your grants from the command line or from a GUI? Have you
done FLUSH
I created users using webmin and I have done FLUSH PRIVILEGES.
[snip]
After I uninstalled 4.1 I removed the /var/db/mysql/ directory so that
the
install of 4.0.6 would start fresh and create its defualt users and
databases with no trace of the previous user entries.
[/snip]
Are you doing
[snip]
I created users using webmin and I have done FLUSH PRIVILEGES.
[/snip]
Are you granting privileges based on 'localhost', '127.0.0.1', or
somewhere else. Where are users logging in from?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
The users are being created with the privelages of being able to login
from any host and they are logging in from the command line through their
shell account.
[snip]
I created users using webmin and I have done FLUSH PRIVILEGES.
[/snip]
Are you granting privileges based on 'localhost',
[snip]
The users are being created with the privelages of being able to login
from any host and they are logging in from the command line through
their
shell account.
[/snip]
So they need to be '[EMAIL PROTECTED]' You gave this ...
[snip]
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]'
Issue has been resolved. Thank you all. I dont know what went wrong but I
think it was becuase when I was connecting as root
I ran :
mysql --user=root
and not mysql --user=root mysql
after I did this I created a user and now that user can connect with a
password.
Thank you all for your help
I am using the command line for grant operations, no flushing though
Why are you using 4.0,6? any special reason? I am using a custom (i
compiled myself) 4.0.16
Here is an example operation:
TRY TO LOG WITHOUT PASS, ERROR
[EMAIL PROTECTED] vmedina]$ mysql
ERROR 1045: Access
By default mySQL comes with a set of users that are allowed to login
locally without password. You should create a normal-superuser account,
and delete all others, and use this user to administer the rest of the
data base and use it to create all others accounts that you might need.
To create a
I have already created extra user accounts and none of them can connect
once a password has been set.
-Original Message-
From: Victor Medina [mailto:[EMAIL PROTECTED]
Sent: 11 December 2003 18:45
To: Schrodinger
Cc: 'MySQL General Lists'
Subject: Re: Login Problems
By default mySQL
[snip]
I have already created extra user accounts and none of them can connect
once a password has been set.
[/snip]
Have you FLUSHED the privileges?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Yes I have tried doing that but with no joy.
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: 11 December 2003 18:59
To: Schrodinger; Victor Medina
Cc: MySQL General Lists
Subject: RE: Login Problems
[snip]
I have already created extra user accounts and none
Medina [mailto:[EMAIL PROTECTED]
Sent: 11 December 2003 18:56
To: Schrodinger
Subject: RE: Login Problems
You should delete most others since there is one user identified by
something like this [EMAIL PROTECTED] that won't let you connect using
password. If you delete those users, you'll be able
Schrodinger wrote:
I have removed all localhost user entries and all users should now be
able to connect from any host. But when a user attempts to connect with
a password they get the usual
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
In an earlier message, you
Have you flushed priv's recently?
-Original Message-
From: Schrodinger [mailto:[EMAIL PROTECTED]
Sent: Monday, December 08, 2003 1:02 PM
To: MySQL General Lists
Subject: Login Problems
Hello, I am experiencing a strange problem with a MySQL server on a
FreeBSD machine here in college.
No I haven't. How do I do that?
-Original Message-
From: Brian Duke [mailto:[EMAIL PROTECTED]
Sent: 08 December 2003 20:07
To: 'Schrodinger'; 'MySQL General Lists'
Subject: RE: Login Problems
Have you flushed priv's recently?
-Original Message-
From: Schrodinger [mailto:[EMAIL
16 matches
Mail list logo