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
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
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',
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
Does anyone know why MySQL would only be allowing users with null
passwords to connect? It's a fresh install of the server after
deinstalling 4.1-ALPHA and installing the production release of 4.0.6.
Conor.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
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
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
Hello, I am experiencing a strange problem with a MySQL server on a
FreeBSD machine here in college. The problem began after I de-installed
the 4.1 ALPHA versions of both the client and the server, removed the
/var/db/mysql/ directory so the install would start afresh and installed
the 4.0.6
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
10 matches
Mail list logo