Michael, group;
Thanks much for the directionsI followed them and solved my problem!!!
Now I've got this issue and I'm not sure what syntax to use to get this
script to run:
[EMAIL PROTECTED]:~/ZoneMinder-1.22.0/db> vi zm_create.sql.in
[EMAIL PROTECTED]:~/ZoneMinder-1.22.0/db> mysql mysql <
Shawn Sharp wrote:
Dilipkumar,
Thanks much for the tipit did the job!
Now we query mysql to see if the new mysql database is seen by mysql and it
still only sees test:
No, you can't see the mysql db, because you don't have permission to access it.
I expect you are still logged in as the
Shawn Sharp wrote:
I get the following error while trying to create the following database
mysql mysql < zm_create.sql.in
ERROR 1044 (42000): Access denied for user ''@'localhost' to database
'mysql'
You are logged into mysql as the anonymous user,
t;
> Use
>
> /usr/bin/mysql_install_db --datadir=/mysql/data --user=mysql
>
> This might help ypu to solve the problem.
>
>
>
> Shawn Sharp wrote:
>
> >I get the following error while trying to create the following database
> >
> >mysql mysql < zm_create.s
t;
> Use
>
> /usr/bin/mysql_install_db --datadir=/mysql/data --user=mysql
>
> This might help ypu to solve the problem.
>
>
>
> Shawn Sharp wrote:
>
> >I get the following error while trying to create the following database
> >
> >mysql mysql < zm_create.s
I get the following error while trying to create the following database
mysql mysql < zm_create.sql.in
ERROR 1044 (42000): Access denied for user ''@'localhost' to database
'mysql'
I tried to run the following script
/usr/bin/mysql_install_db --user
Howdy all,
I keep getting this error when I try to issue:
mysql mysql -u root -p
the same thing happens when I substitute any other database name, not just
mysql. I have another,nearly identical machine from which I copied the
contents of /var/lib/mysql/mysql/ . The permissions all appear to
* to [EMAIL PROTECTED] identified by 'password';
> ERROR 1044 (42000): Access denied for user 'root'
>
> What could be the reason???
> I though the mysql root user was analogous to the unix counterpart
>
> Thanks a lot in advance for your help.
>
>
rnel-Hacker!!! [mailto:[EMAIL PROTECTED] On
Behalf Of
> [EMAIL PROTECTED]
> Sent: Wednesday, December 15, 2004 11:34 AM
> To: [EMAIL PROTECTED]
> Subject: ERROR 1044 (42000): Access denied for user 'root'
>
> Hi,
>
> As the root user I created a DB a populated with ta
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] identified by 'password';
ERROR 1044 (42000): Access denied for user 'root'
What c
sec)
mysql> CREATE DATABASE menagerie;
ERROR 1044: Access denied for user: '@localhost' to database 'menagerie'
You did not start mysql as root.
mysql -u root
I have read the documentation again and again, it show I can create a host file, but
ite does not say what kind file it
sql> CREATE DATABASE menagerie;
ERROR 1044: Access denied for user: '@localhost' to database 'menagerie'
I have read the documentation again and again, it show I can create a host file, but
ite does not say what kind file it is and where I should put it. How can I fix it?
This is what I need.
> >> >
> >> >now the same operations on mysql 4.0.12:
> >> >as root:
> >> >
> >> >mysql> create database test_dummy;
> >> >Query OK, 0 rows affected (0.00 sec)
> &
ry OK, 0 rows affected (0.00 sec)
>mysql> grant all on test_dummy.* to dummy;
>Query OK, 0 rows affected (0.00 sec)
>mysql> set password for 'dummy'=password('testpass');
>Query OK, 0 rows affected (0.00 sec)
>mysql> flush privileges;
>Query O
gt;as root:
> >
> >mysql> create database test_dummy;
> >Query OK, 0 rows affected (0.00 sec)
> >mysql> grant all on test_dummy.* to dummy;
> >Query OK, 0 rows affected (0.00 sec)
> >mysql> set password for 'dummy'=password('tes
ileges;
Query OK, 0 rows affected (0.01 sec)
mysql> exit
Bye
and as a user: dummy:
mysql> set password=password('testpass1');
ERROR 1044: Access denied for user: 'dummy@'' to database 'mysql'
User dummy cannot change his own password
> exit
Bye
and as a user: dummy:
mysql> set password=password('testpass1');
ERROR 1044: Access denied for user: 'dummy@'' to database 'mysql'
User dummy cannot change his own password ...
Any idea how to change it ? Or some hi
Michael Stassen wrote:
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: '
[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]
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'
See #3 below.
I suspect that the problem may be that I never set the password for
mysqladmin
e. 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'
See #3 below.
I suspect that the problem may be that I never set the password for
mysql
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'
[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:
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:
mysql> CREATE DATABASE MYDATABASE;
ERROR 1044: Access denied for user: '@localhost' to database
'mydatabase'
I suspe
[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
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 ran the
"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
: :'
ed the user to access the database,
> and gave all privs with grant option for that database. But when I go to
> run the command to restore the database, I get the following error:
>
> $ mysql -u user -p database < database.sql
> Enter password:
> ERROR 1044 at line 26: Acces
. But when I go to
run the command to restore the database, I get the following error:
$ mysql -u user -p database < database.sql
Enter password:
ERROR 1044 at line 26: Access denied for user: '[EMAIL PROTECTED]' to
database 'database'
I don't understand. Looking a
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]
getting Errors 1044 & 2003. Here's some of the output:
> > >
> > > [EMAIL PROTECTED] root]# mysql -u root mysql
> > > Welcome to the MySQL monitor. Commands end with ; or \g.
> > > Your MySQL connection id is 19 to server version: 4.0.13-log
> > &g
of the output:
> >
> > [EMAIL PROTECTED] root]# mysql -u root mysql
> > Welcome to the MySQL monitor. Commands end with ; or \g.
> > Your MySQL connection id is 19 to server version: 4.0.13-log
> >
> > Type 'help;' or '\h' for help. Type &
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
monitor. Commands end with ; or \g.
> Your MySQL connection id is 19 to server version: 4.0.13-log
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> CREATE DATABASE ;
> ERROR 1044: Access denied for user: '@localhost
; or '\h' for help. Type '\c' to clear the buffer.
mysql> CREATE DATABASE ;
ERROR 1044: Access denied for user: '@localhost' to database ''
mysql> \q
Bye
[EMAIL PROTECTED] root]# mysql -u root -h 127.0.0.1
ERROR 2003: Can't connect to MySQL s
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 permis
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'
--
Ed Kiefer
Advantage Mail Services
--
MySQL General Mailing List
For list archives:
If you want to set the root password you can do the next thing
1. kill the mysqld
2. start mysqld with --skip-grant-tables option
3. set the new password with
mysqladmin -u root password 'RogerTheRabbit'
command
4. and finally - mysqladmin -h hostname flush-privileges
instead of 3 and 4 you
g in successfully to the
mysql monitor on command line:
GRANT all privileges on mydatabase.* to ""@localhost;
and got the following:
Error 1044: access denied for [EMAIL PROTECTED]
Paul, I hope I'm being specific enough on the code and error messages - it's
clear to me that
I have an application that has stopped working after the ISP upgraded from
MySQL 3.23.36 to MySQL 4.0.11a-gamma-log
All I'm told is:
ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'jomaridb'
This is a commercial server so I have no access
application stopped.
I am connecting from root user to the server and if I issue a command
# mysql -D bugs -u bugs@localhost
It gives the error "Access denied for the user bugs@localhost" (Error - 1044)
However If I issue the command
#mysql -D bugs -u bugs
Then it connects to the
am getting the error when trying to connect server from my client:
>
> ERROR 1044: Access denied for user: '@NRICRIV1.ad.rivenet.com' to database
> 'mysql'
>
> any answer?
>
> thanks,
>
> anjani
>
>
> --
Hi all,
I am getting the error when trying to connect server from my client:
ERROR 1044: Access denied for user: '@NRICRIV1.ad.rivenet.com' to database
'mysql'
any answer?
thanks,
anjani
-
Before p
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
--
econd user has exactly the same config as the first one, but with less
privileges : only the Select_priv, Insert_priv, Update_priv and Delete_priv
set to 'Y' for the db "hello".
I can connect my sql with that user, but I can't use the db hello :
mysql> use he
fy if the pass was set... it was.
>
> then i stopped mysql and restart it and it was impossible connecting
> again. here is the detailed result :
>
> Linux>bin/mysql -u root -p
> Enter password :
> mysql >use mysql
> Database changed
> mysql>SELECT * FROM use
ped mysql and restart it and it was impossible connecting
again. here is the detailed result :
Linux>bin/mysql -u root -p
Enter password :
mysql >use mysql
Database changed
mysql>SELECT * FROM user;
ERROR 1044:Access Denied for user: '@localhost' to database 'mysql'
ERROR:
- 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 d
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 password i can connect but if i write:
mysql> use mysql
i've got the same message, so i can't do anything neither connect nor
create database,tabl
67 matches
Mail list logo