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 'root'@'localhost (using password:'NO')
how can I
-29 15:36 GMT-03:00 Kishore Vaishnav kish...@railsfactory.org:
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
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 user
MariaDB connection id is 16056
Server version: 5.5.37-MariaDB-log thelounge
Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.
MariaDB [(none)]
Am 29.05.2014 21:19, schrieb Érico:
running
hi
I am facing the following :
mac:mysql-5.6.16-linux-glibc2.5-x86_64 ericomtx$ sudo
scripts/mysql_install_db --user=mysql
sh: ./bin/my_print_defaults: cannot execute binary file
FATAL ERROR: Neither host 'mac.local' nor 'localhost' could be looked up
with
./bin/resolveip
Please configure the
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:
13.01.2014 23:59, schrieb Érico:
true
but please check this out :
mysql Select user, host, password from mysql.user;
+--+--+---+
| user | host | password
#fe80::1%lo0localhost
127.0.0.1 ericomtxmacbookpro.local
127.0.0.1 mysqld
Thks
É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 h.rei...@thelounge.net
Am 13.01.2014 18:28, schrieb Érico
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 web app as
you've been told in the mail before.
On 13 January 2014 12:36, Reindl Harald h.rei...@thelounge.net wrote:
Am 13.01.2014 18:28, schrieb Érico
;
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, Érico erico...@gmail.com wrote:
using localhost the coonection works ...
ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin -h
/etc/hosts file :
##
127.0.0.1 localhost
255.255.255.255 broadcasthost
::1 localhost
#fe80::1%lo0localhost
127.0.0.1 ericomtxmacbookpro.local
#127.0.0.1 mysqld
2014/1/13 Erick Ocrospoma zipper1...@gmail.com
On 13 January 2014 13:25, Érico erico...@gmail.com
not connect through
command line
Thks
2014/1/13 shawn l.green shawn.l.gr...@oracle.com
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
I have followed the steps from bellow to install mysql from src on my linux
( red hat 6 ) :
shell groupadd mysql
shell useradd -r -g mysql mysql
# Beginning of source-build specific instructions
shell tar zxvf mysql-VERSION.tar.gz
shell cd mysql-VERSION
shell cmake .
shell make
shell make install
14 matches
Mail list logo