Am 29.05.2014 20:22, schrieb Érico:
I have ran the following to test a fix for an app issue :
delete from mysql.user where user='';
2lines got effected
after this I can´t connect through command line anymore :
./mysqladmin -u root password pwd
I get access denied for user
Did you tried this..
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
*thanks,*
*-- *Kishore Kumar Vaishnav
On Thu, May 29, 2014 at 11:22 AM, Érico erico...@gmail.com wrote:
I have ran the following to test a fix for an app issue :
delete from mysql.user where user='';
Hi
thanks but it is not working either
I wonder if the 2 rows I removed (with empty users for localhost and my
computer names) were responsilbe for allowing the autentication ?
how this table works ?
what mysql checks on it ? the pwd column ? if it is filled ?
what if I have 2 records for
running this :
./mysqladmin -u root -p
at this momento it thorws me to mysqladmin man page
2014-05-29 15:35 GMT-03:00 Reindl Harald h.rei...@thelounge.net:
Am 29.05.2014 20:22, schrieb Érico:
I have ran the following to test a fix for an app issue :
delete from mysql.user where
well, i am mysql administrator over 10 years now
and never needed the mysqladmin command because
the mysql command line client offers anything i
ever needed
mysql -u root -p
[harry@srv-rhsoft:~]$ mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your
Hello Érico
On 5/29/2014 2:22 PM, Érico wrote:
I have ran the following to test a fix for an app issue :
delete from mysql.user where user='';
2lines got effected
after this I can´t connect through command line anymore :
./mysqladmin -u root password pwd
I get access denied for user
I am really sorry about this one ..
the connection is ok ...
I had not checked that I was using mysqladmin instead of mysql
now please how can I check what is wrong with my application ( My SQL Admin
)
at its login page it asks for user / pwd / server and db
using both localhost and 127.0.01
Hello Érico,
On 5/29/2014 3:51 PM, Érico wrote:
I am really sorry about this one ..
the connection is ok ...
I had not checked that I was using mysqladmin instead of mysql
now please how can I check what is wrong with my application ( My SQL Admin
)
at its login page it asks for user / pwd
ok
I have tried these :
ifconfig -a
lo0: flags=8049UP,LOOPBACK,RUNNING,MULTICAST mtu 16384
inet6 ::1 prefixlen 128
inet6 fe80::1%lo0 prefixlen 64 scopeid 0x1
inet 127.0.0.1 netmask 0xff00
gif0: flags=8010POINTOPOINT,MULTICAST mtu 1280
stf0: flags=0 mtu 1280
fw0:
Hi
| | ericomtxmacbookpro.local |
*E85DC00A0137C6171923BE35EDD809573FB3AB4F |
mysql DELETE FROM mysql.user WHERE user='';
mysql FLUSH PRIVILEGES;
maybe helps?
Cheers
--
Claudio
yes it is ...
also , the eclipse is also local ...
in both ... mysql-admin php application , plus inside eclispe plugin ...
same behavior in both
2014/1/13 Reindl Harald h.rei...@thelounge.net
i doubt that the webserver is running on the same
machine as your mysql command shell
Am
Am 13.01.2014 18:28, schrieb Érico:
ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 31
Server version: 5.6.15 MySQL Community Server (GPL)
but in the browser I get the
From that error I would suspect you are trying to access to a database
where has not external access. And yeah, try by doing
$ mysql -u root -p database -h localhost -P 3306
change localhost by 127.0.0.1 in order to test if both cases work, and
see which of them (localhost/127.0.0.1) is defined
using both urls I get the same error :
http://localhost/mysql/index.php
http://127.0.0.1/mysql/index.php
in 127.0.0.1... after I submit the index.php ... it redirects to localhost
too ..
2014/1/13 Reindl Harald h.rei...@thelounge.net
Am 13.01.2014 18:28, schrieb Érico:
using localhost the coonection works ...
ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin -h
localhost -P 3306
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL
I presume your index.php file uses 127.0.0.1. After login to MySQL try this:
$ grant all privileges to *.* 'root'@'127.0.0.1' identified by yourpassword;
Of course this could not be the best solution, it's just to skip it,
you must look at the query/connection on your php file.
On 13 January
I forgot this. Do it too.
On 13 January 2014 13:01, Erick Ocrospoma zipper1...@gmail.com wrote:
I presume your index.php file uses 127.0.0.1. After login to MySQL try this:
$ grant all privileges to *.* 'root'@'127.0.0.1' identified by
yourpassword;
$ flush privileges;
Of course this could
the granting is not affecting the tables:
mysql grant all privileges on *.* to root@localhost identified by 'pwd';
Query OK, 0 rows affected (0.00 sec)
mysql FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
...
and if I try the granting in 127.0.0.1 :
mysql grant all privileges to *.*
On 13 January 2014 13:25, Érico erico...@gmail.com wrote:
the granting is not affecting the tables:
mysql grant all privileges on *.* to root@localhost identified by 'pwd';
Query OK, 0 rows affected (0.00 sec)
mysql FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
...
and if I try
Hi
didn't work
look ... isn't this something related to this :
are you using localhost or 127.0.0.1 in the web-application
root@localhost != root@127.0.0.1 = different users
localhost: Unix-Socket
127.0.0.1: TCP
...
since I am not able to stabilsh a connection even with using eclipse ...
my
Hello Érico,
On 1/13/2014 1:49 PM, Érico wrote:
Hi
didn't work
look ... isn't this something related to this :
are you using localhost or 127.0.0.1 in the web-application
root@localhost != root@127.0.0.1 = different users
localhost: Unix-Socket
127.0.0.1: TCP
...
since I am not able to
Hi
no connections outside command line are being accepted . I have connected
through command line , but not using eclipse for example ... it gets the
same error from the web app
my apache and pages are in the same computer that mysql
I am not getting password issues.. otherwise I would not
WTF - we are talking about *database connections* and *not* http-URL's
the webserver is only the *messenger*
Am 13.01.2014 18:54, schrieb Érico:
using both urls I get the same error :
http://localhost/mysql/index.php
http://127.0.0.1/mysql/index.php
in 127.0.0.1... after I submit the
*your application* is connecting to mysql
*your application* is using a hostname
*your application* *may* use 127.0.0.1
*your application* should use localhost to *connect to the databse*
*your application* can only use TCP *if there is* a *mysql user* with *that
host*
Hello Reindl,
On 1/13/2014 3:01 PM, Reindl Harald wrote:
*your application* is connecting to mysql
*your application* is using a hostname
*your application* *may* use 127.0.0.1
*your application* should use localhost to *connect to the databse*
*your application* can only use TCP *if there is*
provide the output of the below query.
Select user, host, password from mysql.user;
Thanks
Vikas Shukla
Mail Sent from my Windows Phone From: Reindl Harald
Sent: =E2=80=8E14-=E2=80=8E01-=E2=80=8E2014 01:38
To: mysql@lists.mysql.com
Subject: Re: Access denied for user 'root'@'localhost' (using
Am 13.01.2014 21:47, schrieb shawn l.green:
Hello Reindl,
We are not saying he is using HTTP commands to log into his database
we excludes obviously the OP or his overall understanding :-)
Am 13.01.2014 18:54, schrieb Érico:
using both urls I get the same error :
Hi Jesse,
If you're specifying the password in plain text, you shouldn't put the
PASSWORD directive in there; you only use PASSWORD if you're using the
hashed password that MySQL will actually store.
GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED
BY 'LongPasswordHere'
That was it. Once I removed PASSWORD, it went through, and I'm able to restart
MySQL now.
Thanks for your help.
Jesse
- Original Message -
From: Ian Simpson
To: Jesse
Cc: MySQL List
Sent: Tuesday, July 22, 2008 4:48 AM
Subject: Re: Access denied for user 'debian-sys
Do you login via sock or network ?
Didja change the passwd for localhost and % ?
--Original Message--
From: Jesse
To: MySQL List
Sent: Jul 21, 2008 17:35
Subject: Access denied for user 'debian-sys-maint'@'localhost'
OK. This is driving me Nutz 8-p
Any time I try to restart mysql, I
Car Toper wrote:
More info...
I am able to login with the account via phpMyAdmin on the server.
Also, I am trying to use phpMyAdmin to change the permissions, but I
cannot figure out the syntax:
GRANT ON ppsntracker.* TO [EMAIL PROTECTED] WITH GRANT OPTION;
Cartoper
On 8/21/07, Car
More info...
I am able to login with the account via phpMyAdmin on the server.
Also, I am trying to use phpMyAdmin to change the permissions, but I
cannot figure out the syntax:
GRANT ON ppsntracker.* TO [EMAIL PROTECTED] WITH GRANT OPTION;
Cartoper
On 8/21/07, Car Toper [EMAIL PROTECTED]
message would be the one that I'm getting?
Thanx in advance,
Jorge
From: Gleb Paharenko [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: Re: Access denied for user: '[EMAIL PROTECTED]' (Using password:
NO)
Date: Mon, 18 Apr 2005 18:38:54 +0300
Hello.
It is strange that refusing message says
Hello.
Could be that the connect command fails, then I start trying and trying,
and then the server blocks because it receives too many connections? Then
the error message would be the one that I'm getting?
I also thought about this and therefore I gave you that advice. What
is
Hello.
It is strange that refusing message says you're not using passwords.
Does the problem disappear after the FLUSH HOSTS statement, instead of
restarting MySQL server?
Jorge Cambra Aused [EMAIL PROTECTED] wrote:
I have a web application running with Apache with PHP 4.1.2
Hello.
I successufully connected to MySQL server using your parameters
in odbc.ini and odbcinst.ini files from php.
[unixODBC][MySQL][ODBC 3.51 Driver]Access denied for user:
'[EMAIL PROTECTED]' (Using password: NO)
You have specified the user and the password in the ODBC
hi
you are not passing a password to mysql - check your code to see if this is
correct.
Peter
-Original Message-
From: Christian Biggins [mailto:[EMAIL PROTECTED]
Sent: 26 January 2005 12:27
To: mysql@lists.mysql.com
Subject: Access denied for user - I cant work this out
Hi All,
: Peter Lovatt [mailto:[EMAIL PROTECTED]
Sent: Thursday, 27 January 2005 12:27 AM
To: Christian Biggins; mysql@lists.mysql.com
Subject: RE: Access denied for user - I cant work this out
hi
you are not passing a password to mysql - check your code to see if this is
correct.
Peter
-Original
Subject: RE: Access denied for user - I cant work this out
Hi Peter,
There is a password being suppled - see code (btw, its local testing only,
hence the root user)
//Database Settings
$db_host = 'localhost'; //database hostname $db_name =
'powerpla_powerplay'; //database name $db_user
');
}
}
HTH
Peter
-Original Message-
From: Christian Biggins [mailto:[EMAIL PROTECTED]
Sent: 26 January 2005 13:30
To: 'Peter Lovatt'; mysql@lists.mysql.com
Subject: RE: Access denied for user - I cant work this out
Hi Peter,
There is a password being suppled - see code (btw
Re-installing does not get rid of your old passwords.
You need to use the -p option.
Nguyen, Long P (Mission Systems) wrote:
Hi -
I am new to MySQL - I just recently re-installed MySQL by rpm and when ever I try to issue
a command from the shell prompt, such as mysqladmin or mysqlshow, I would
(Mission Systems)
Cc: [EMAIL PROTECTED]
Subject: Re: Access denied for user: '[EMAIL PROTECTED]' (Using password:
NO)
Re-installing does not get rid of your old passwords.
You need to use the -p option.
Nguyen, Long P (Mission Systems) wrote:
Hi -
I am new to MySQL - I just recently re
On Thursday 01 July 2004 09:08 am, Nguyen, Long P (Mission Systems) wrote:
shouldn't I be able to issue commands at the shell it goes and does it
thing and give back output? or does this mean I have a passwd already set
and it's secured?
Phil Ewington - 43 Plc [EMAIL PROTECTED] wrote:
Hi All,
I have just installed mysql-4.0.18 on my cobalt RaQ4 and for the first time
seemed to actually got somewhere! however, my existing PHP scripts failed to
connect to localhost as the password has not been set after the install. I
ran the
when establishing
connection.
(But I never tried to make connection from COBOL, I'm just using MYSQL C API
from C++)
- Original Message -
From: Arunachalam [EMAIL PROTECTED]
To: KKoTY [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, February 06, 2004 6:21 AM
Subject: Re: Access denied
PROTECTED]
Sent: Friday, February 06, 2004 6:21 AM
Subject: Re: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
I have installed MyODBC 3.51 and created the DSN for my Database.
I want to clarify that;
If the User name I have given is could not be resolved
You have attempted to login with out supplying a username. Try logging in
like:
mysql -uusername -ppassword
Original Message
On 2/5/04, 8:38:13 AM, Arunachalam [EMAIL PROTECTED] wrote regarding
Access denied for user: '[EMAIL PROTECTED]' (Using password: YES):
Hi all,
Is any one met
Arunachalam wrote:
Hi all,
Is any one met with the error while connecting to MySQL Server
*Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)*
OK, you tried to log into mysql as [EMAIL PROTECTED], using a password.
if so pleass let me know the remedy to resolve this error.
I
this occures when you ommit the user name, MYSQL C API uses user ODBC as
default when you ommit or enter empty string as
user name when calling mysql_real_connect()
- Original Message -
From: Arunachalam [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 05, 2004 3:38 PM
I have installed MyODBC 3.51 and created the DSN for my Database.
I want to clarify that;
If the User name I have given is could not be resolved by mysal_real_connect,
then it automatically establish the connection to the server using
[EMAIL PROTECTED] - right
If so, Is there need to have the
For Mysql, 127.0.0.1 is not the same as localhost.
Localhost refers to the socket file on the operating system, and is
faster than 127.0.0.1.
Use 'root'@'127.0.0.1' in your grant statements.
Ola Ogunneye wrote:
Please somebody help me.
I have installed MySql 4.0.13 and it works up until I try
Did you flush the privileges after you gave root a password?
The error you get is a result of not using a password to login.
-Original Message-
From: Ola Ogunneye [mailto:[EMAIL PROTECTED]
Sent: Monday, June 30, 2003 6:05 PM
To: [EMAIL PROTECTED]
Subject: Access Denied for User: [EMAIL
You can try one or the other
mysql -h localhost -u root -ppasswd db
or
mysql -h `uname -n` -u root -ppasswd db
in solaris
On Mon, 30 Jun 2003, Twibell, Cory L wrote:
Did you flush the privileges after you gave root a password?
The error you get is a result of not using a password to login.
don't piggyback on other people's threads. you can start your own
for free.
# [EMAIL PROTECTED] / 2003-06-19 13:23:04 -0700:
I ran a command which was part of the installation process for some php
accounting software.
update user set host='%' where host='localhost' and user='root';
use: mysqladmin -u root -p
It will prompt you for the password
On Tue, 2002-11-05 at 10:03, Jack Chen wrote:
Dear all,
When I ran the follwing command:
$ mysqladmin -u root password PASSWORD
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user:
Stangely, it gave me a page of *information* like this: [any idea?
thanks!]
mysqladmin Ver 8.23 Distrib 3.23.49, for redhat-linux-gnu on i386
Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are
right, sorry, I could have been more specific.
like so: mysqladmin -u root -p command, command...
example: mysqladmin -u root -p create mytestdatabase
On Tue, 2002-11-05 at 10:33, Jack Chen wrote:
Stangely, it gave me a page of *information* like this: [any idea?
thanks!]
mysqladmin Ver
Jack Chen wrote:
$ mysqladmin -u root password PASSWORD
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
Could you inform me why?
That's why:
$ mysqladmin -uroot -pyourpassword PASSWORD newpassword
--
./ premax
./
Thanks, but I still got complains that can't access server:
'Access denied for user: 'root@localhost' (Using password: YES)
Is it possible that for some reason the password is wrong?
You input is greatly appreaciated,
Puzzled newbie,
Jack
Jack
Just a question, did you ever change your password for Mysql? If not
don't use the -p option
mysqladmin -u root create testdb
On Tue, 2002-11-05 at 11:08, Jack Chen wrote:
Thanks, but I still got complains that can't access server:
'Access denied for user: 'root@localhost' (Using
Jack,
Tuesday, November 05, 2002, 6:08:58 PM, you wrote:
JC Thanks, but I still got complains that can't access server:
JC 'Access denied for user: 'root@localhost' (Using password: YES)
JC Is it possible that for some reason the password is wrong?
Yup. If you don't remember 'root' password,
Hi,
You forgot : FLUSH PRIVILEGES;
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: luoya li [EMAIL PROTECTED]
luoya,
Wednesday, October 02, 2002, 8:32:21 AM, you wrote:
ll I have Mysql 3.23.52-max-nt on Win2K. I¡¯d like to set a password for root
ll so I use the following commands:
ll mysql use mysql
ll Database changed
ll mysql update user set password=password('l05m')
ll - where
Hello list,
I am attempting to run:
perl -MCPAN -e 'install DBD::mysql'
I am having a similar problem as the message that is in this subject line,
reported by Jon Ingason in a message dated March 1, 2002. I must have
tried the install routine at least 15 times, varying different settings that
Are you using the latest version of DBI? Also, your if ($dbh) { seems a
little backward. According to the DBI docs, If the connect fails (see
below) it returns undef and sets $DBI::err and $DBI::errstr. So shouldn't
your conditional be if (!$dbh) {. Perhaps you are actually connecting.
I'm not
LdS I'm experiencing the same problem.
LdS But I sort of found a way around it (though I'm sure this is not really the
right way).
LdS When I remove the *password* for *root* and login again as root, I'm able to
create new users using GRANT then flush priviliges.
LdS Does this mean I have to
Hi
check if mysqld is running if not start it and try again.
daniel
josep wrote:
I get the following message when trying to view a php page
Warning: Access denied for user: 'jupshoes@localhost' (Using password: YES)
in /home/jupshoes/public_html/guest/index.php on line 27
Unable to connect
67 matches
Mail list logo