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
Hi guys!
I am facing some problems trying to login user to the data base server
using --any-- client(except the mysql cli) to the server. Users using no
password does not seems to have any problems.
It happens that when a client tries to log into the db server using
passwords the server doesn't
At 14:42 -0400 12/12/03, Victor Medina wrote:
Hi guys!
I am facing some problems trying to login user to the data base server
using --any-- client(except the mysql cli) to the server. Users using no
password does not seems to have any problems.
It happens that when a client tries to log into the
At 14:42 -0400 12/12/03, Victor Medina wrote:
It happens that when a client tries to log into the db server using
passwords the server doesn't seems to authorize. Even the most recent
MyCC client fails to autorize users using passwords. Do I need to
compile the clients against the new server's
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
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
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
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
Okay, I just found out what I was doing wrong. Having looked in the docs,
but I'm sure this is documented behavior.
MySQL 4.0.12, MSW2k. Here's what's puzzling me --
I set up a new user yesterday. I'm pretty sure I was able to connect as
the user from the command line yesterday, before I
MySQL 4.0.12, MSW2k. Here's what's puzzling me --
I set up a new user yesterday. I'm pretty sure I was able to connect as
the user from the command line yesterday, before I shut my machine down
and went home. I can't today.
I have this user entry in my mysql.user table:
| localhost | fromWeb |
Hi I'm Mere!
I've just installed mysql for use of bugzilla.I was logging well all the time
and suddenly my super user root can't access the databases especially mysql.In
short root can't access mysql even if I'm using the password I use to login
with.The surprise is that bugs as a user does
24 matches
Mail list logo