ok
I have tried these :
ifconfig -a
lo0: flags=8049 mtu 16384
inet6 ::1 prefixlen 128
inet6 fe80::1%lo0 prefixlen 64 scopeid 0x1
inet 127.0.0.1 netmask 0xff00
gif0: flags=8010 mtu 1280
stf0: flags=0<> mtu 1280
fw0: flags=8863 mtu 4078
lladdr 70:cd:60:ff:fe:eb:72:ea
media:
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
> i doubt that the webserver is running on the same
> machine as your mysql command shell
>
> Am 13.01.2014 23:59,
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
fer-Encoding: quoted-printable
Please 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 den
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
*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
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
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
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
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 ...
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
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 *.*
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
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,
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
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
>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
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
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?
>
http://dev.mysql.com/doc/mysql/en/User_Account_Mana
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?
-Original Message-
From: gerald_clark [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 01, 2004 8:57 AM
To: Nguyen, Long P (M
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 ge
"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
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,
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 passwo
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
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
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 Ve
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 wel
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: 'root
30 matches
Mail list logo
