Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Reindl Harald
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 : > > http://localhost/mysql

RE: Access denied for user 'root'@'localhost' (using password:

2014-01-13 Thread Vikas Shukla
YES) on mysql admin MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="wmcsLTXQx7E3jAVxUD1b39Xfw2SDoi7cu" --wmcsLTXQx7E3jAVxUD1b39Xfw2SDoi7cu Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Pl

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread shawn l.green
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* a

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Reindl Harald
*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* http://dev.mysql.com/doc/re

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Reindl Harald
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

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Érico
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 conne

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread shawn l.green
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

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Érico
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 ...

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Erick Ocrospoma
On 13 January 2014 13:25, Érico 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 the g

Re: grouping by the difference between values in rows

2014-01-13 Thread Larry Martell
On Mon, Jan 13, 2014 at 2:43 AM, Peter Brawley wrote: > > On 2014-01-12 9:13 PM, Larry Martell wrote: >> >> On Sun, Jan 12, 2014 at 2:47 PM, Peter Brawley >> wrote: >>> >>> On 2014-01-12 1:17 PM, Larry Martell wrote: I've been asked to do something that I do not think is possible in SQL

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Érico
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 *.*

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Erick Ocrospoma
I forgot this. Do it too. On 13 January 2014 13:01, Erick Ocrospoma 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 > ; $> flush privileges; > > Of course this could not be the best soluti

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Erick Ocrospoma
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 ; 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 2014 12:57,

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread É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 monit

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread É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 index.php ... it redirects to localhost too .. 2014/1/13 Reindl Harald > > > Am 13.01.2014 18:28, schrieb Érico: > > ericomtxmacbookpro:bin ericomtx$ ./m

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Erick Ocrospoma
>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 -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 in your

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Reindl Harald
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

Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Érico
Hi I have installed mysql admin on my local environment I am able to connect to mysql through command line : 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.