Hello.
What says:
show grants for current_user();
[EMAIL PROTECTED] wrote:
> Hi,
>
> As the root user I created a DB a populated with tables... but when I want
> to create a user to handle that DB i get this error message:
>
> mysql> grant all on db.* to [EMAIL PROTECTED] ident
Ed,
It sounds like root doesn't have the GRANT permission for the localhost.
You can check by querying the User table in mysql.
--Dave
David W. Juntgen
Medical Informatics Engineering Inc.
Phone: 260.459.6270
Fax : 260.459.6271
> -Original Message-
> From: Guru Vai Kernel-Hacker!!! [m
c s wrote:
Dear friends,
I have a question about mysql.
I installed mysql on windows 2000, after I started the mysql, I tried to create a
database, but I was denied, I got message:
mysql> show databases;
+--+
| Database |
+--+
| test |
+--+
1 row in set (0.00 sec)
mysq
mysqladmin isn't interactive -- it expects a command to process. With
no command, mysqladmin prints a help message then quits. It doesn't
need a password for that.
For example, to tell the mysql server to shut down, you enter
mysqladmin -u root -p shutdown
You should be prompted for the pa
[snip]
Please RTFM at http://www.mysql.com/doc/en/GRANT.html
[/snip]
Sorry, I pulled the send trigger too fast. My bad.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Both mysql and mysqladmin get user info for login purposes from the same
place: the mysql.user table.
Mysql doesn't have a root password set by default after installation.
It's very easy to overlook this and not set a password. One might think
that the user you're logging into mysql with will
Michael:
You were correct. My problem was that I had set a password for mysql
but didn't realize that I had successfully done so (newbie confusion).
I can now create a database. Unfortunately, there is an additional
issue: it appears as though I didn't set a password for mysqladmin (or
I did s
Jay Blanchard wrote:
[snip]
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
Please help. Thanks in advance.
[/snip]
Please RTFM at http://www.mysql.com/doc/en/GRANT.html
That's an excellent page to
Ralph McCarthy wrote:
Hi:
I've just installed MySQL on Mac OS X 10.2.8. I'm unable to create a
database. When I try to do so, I get the following error message:
I have the same setup.
mysql> CREATE DATABASE MYDATABASE;
ERROR 1044: Access denied for user: '@localhost' to database 'mydatabase'
Se
[snip]
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
Please help. Thanks in advance.
[/snip]
Please RTFM at http://www.mysql.com/doc/en/GRANT.html
--
MySQL General Mailing List
For list archives:
[EMAIL PROTECTED] wrote:
> I recently downloaded MySQL v3.23 on my Windows 2000 laptop. When I try to
> create a database at the mysql> prompt, I get the message "Error 1044:
> Access denied for user '@localhost' to database xx." I originally
> assigned a username and password when I first ra
"Carl B. Constantine" <[EMAIL PROTECTED]> wrote:
> * Victoria Reznichenko ([EMAIL PROTECTED]) wrote:
>> It means that user doesn't have ALTER privilege.
>
> BUT, I've tried granting the user all privs in mysqlcc and it still
> doesn't work. Looking at my other setup, the users look like they are
>
* Victoria Reznichenko ([EMAIL PROTECTED]) wrote:
> It means that user doesn't have ALTER privilege.
BUT, I've tried granting the user all privs in mysqlcc and it still
doesn't work. Looking at my other setup, the users look like they are
set up the same.
--
.''`. Carl B. Constantine
: :'
"Carl B. Constantine" <[EMAIL PROTECTED]> wrote:
> I'm trying to move a database from one machine to another. I dumped the
> database and successfully loaded it on one machine, but I can't do it on
> another machine.
>
> I have the database set up. I created the user to access the database,
> and
Here's the last couple of items from the error log.:
Number of processes running now: 0
030707 21:03:37 mysqld restarted
030707 21:03:37 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence
Hi Kevin,
In this case the error log file (hostname.err) in f.e /var/lib/mysql should
give you an idea whats going on.
Perhaps the settings inside the my.cnf from the newer version are very
different then from the older version.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 10日 木曜日 11:
This is probably a dead horse but let me post a followup to let everyone
know what I did and what has happened since. Maybe I should list it
under some other error number.
Before Paul posted his message I uninstalled (using rpm -e) version
4.0.13. I then got the RedHat installation CDs and re
Hi Paul,
A good lesson to learn ;-).
What you are saying actually means that Kevin didnt need to install it again.
I must have missed this part in the manual.
Thank you for pointing this out.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 9日 水曜日 11:14、Paul DuBois さんは書きました:
> At 10:35 +0900 7/
At 10:35 +0900 7/7/03, Nils Valentin wrote:
2003îN 7åé 7ì åéójì 10:28ÅANils Valentin ÇÇÒÇÕèëÇ´ÇÐǵÇ:
Hi Kevin,
try this:
1) stop the mysql server
2) mysqld_safe --skip-grant-tables
3) mysql -u root
4) mysql> SHOW GRANTS FOR root;
5) GRANT ALL ON *.* TO 'root'@'%';
GRANT ALL ON *.* TO
"Kevin H. Phillips" <[EMAIL PROTECTED]> wrote:
> Hi, Nils
> I was able to stop the mysqld daemon using the kill command. However,
> when I tried to start it using mysqld_safe --skip-grant-tables, a line
> would appear saying:
> [EMAIL PROTECTED] root]# mysqld_safe --skip-grant-tables
> Starting
2003年 7月 8日 火曜日 11:40、Kevin H. Phillips さんは書きました:
> Hi, Nils
> I just thought that it would be better, more particularized, for my
> system. Would it be better to use the precompiled rpms?
Generally talking I believe you can avoid some trouble by using the provided
rpm binary packages. However,
Forgot to mention that I installed from an rpm. I rebuilt a source rpm.
Kevin
Nils Valentin wrote:
How did you install the mysql server (rpm or tar.gz ) ?
Best regards
Nils Valentin
Tokyo/Japan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi, Nils
Here's what I get:
mysql> GRANT ALL ON *.* TO '[EMAIL PROTECTED]' IDENTIFIED BY 'password'
WITH GRANT OPTION;
ERROR 1047: Unknown command
mysql>
I'm sorry I should have asked before if the apostrophes were necessary.
And, the first one is an apostrophe and not the little tilted
apostr
2003年 7月 8日 火曜日 10:25、Kevin H. Phillips さんは書きました:
> Hi, Nils
> OK, here's a copy of the terminal screen I am getting after killing the
> mysqld daemon and then re-starting it:
>
> [EMAIL PROTECTED] root]# ps ax |grep mysqld
> 32309 pts/0S 0:00 /bin/sh /usr/bin/mysqld_safe --skip-grant-tabl
Hi, Nils
OK, here's a copy of the terminal screen I am getting after killing the
mysqld daemon and then re-starting it:
[EMAIL PROTECTED] root]# ps ax |grep mysqld
32309 pts/0S 0:00 /bin/sh /usr/bin/mysqld_safe --skip-grant-tables
32334 pts/0S 0:00 /usr/libexec/mysqld --basedir=
Hi Kevin;
Try to start it as
mysqld_safe --skip-grant-tables &
to start the service in the background, you will then be able to continue in
the same window. Sorry I didn't mention this.
Can you post the grant command you try exactly as it is to the mailing list
please (without password of c
Hi, Nils
I was able to stop the mysqld daemon using the kill command. However,
when I tried to start it using mysqld_safe --skip-grant-tables, a line
would appear saying:
[EMAIL PROTECTED] root]# mysqld_safe --skip-grant-tables
Starting mysqld daemon with databases from /var/lib/mysql
with the
Hi Kevin,
There is a way to sop the server on OS level. However I am not sure if you
want to do it this way. You can use the kill command, but be aware that it
might damage a data file if the database is accessing it in just this moment.
Having said this warning, here is what you can do:
1) ps
Hi, Nils
I can't get the mysql server to stop! If I try "service mysqld stop" I
get a "FAILED" error. If I try mysqladmin -u root -p shutdown, I get:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)'
[EMAIL PROTECTED]
2003年 7月 7日 月曜日 10:28、Nils Valentin さんは書きました:
> Hi Kevin,
>
> try this:
>
> 1) stop the mysql server
> 2) mysqld_safe --skip-grant-tables
> 3) mysql -u root
> 4) mysql> SHOW GRANTS FOR root;
> 5) GRANT ALL ON *.* TO 'root'@'%';
GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY 'secret' WITH GRANT OPTI
Hi Kevin,
try this:
1) stop the mysql server
2) mysqld_safe --skip-grant-tables
3) mysql -u root
4) mysql> SHOW GRANTS FOR root;
5) GRANT ALL ON *.* TO 'root'@'%';
6) restart the server (without --skip-grant-table option) and try to login
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 5日 土
Here's what I get:
mysql> SELECT USER();
++
| USER() |
++
| [EMAIL PROTECTED] |
++
1 row in set (0.02 sec)
mysql>
Kevin
Victoria Reznichenko wrote:
What is the output of SELECT USER()?
--
MySQL General Mailing List
For list archives: h
"Kevin H. Phillips" <[EMAIL PROTECTED]> wrote:
> I am trying to set up mysql 4.0.13 on my RedHat 9 machine. I rebuilt
> the source rpm. (I had a previous installation which I deleted first).
>
> I can log on to the mysql monitor as root but can't creat databases,
> can't change passwords, can't
Ed Kiefer <[EMAIL PROTECTED]> wrote:
> I keep getting this error when I try to create a new database:
>
> mysql> create database cheese_catalog;
> ERROR 1044: Access denied for user: '@localhost' to database'cheese_catalog'
User doesn't have permissions to create database.
--
For technical su
It means you don't have enough privileges to access
'mysql' database. You can add these privileges using
"GRANT" command under user 'root' (or under another
superuser). Check manual, the section about privileges.
anjani.sinha wrote:
> Hi all,
>
> I am getting the error when trying to connect se
TECTED]>
Sent: Tuesday, August 28, 2001 4:39 PM
Subject: Re: ERROR 1044: Access denied
>
> - Original Message -
> From: "Dana Powers" <[EMAIL PROTECTED]>
> To: "Pierre-Yves" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: W
- Original Message -
From: "Dana Powers" <[EMAIL PROTECTED]>
To: "Pierre-Yves" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, August 29, 2001 1:22 AM
Subject: Re: ERROR 1044: Access denied
> > ERROR 1044: Access denied for u
> ERROR 1044: Access denied for user: '@localhost' to database 'hello'
This says that you are connected as user '' ( blank ) from localhost. Make
sure you're logging on correctly and try again.
dpk
-
Before posting, please check
Franck ABELLI writes:
> To change the root password i connected to mysql: bin/mysql
> mysql>connect mysql localhost
> mysql>UPDATE user set Password='***' where User='root';
> ->No problems
> mysql>SELECT User,Password FROM user;
> -> to verify if the pass was set... it was.
>
> then i stopped my
- Original Message -
From: "Franck ABELLI" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 11, 2001 23:29
Subject: ERROR 1044
> i can now connect to mysql but when i login as root with the root
> password i get the ERROR 1044 : Access denied.
> if i don't give any pa
40 matches
Mail list logo
