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
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
18 matches
Mail list logo
