Dnia 11 maja 2016 12:23 Marcin marcin@nicram.net napisał(a):
mysql> show grants for 'root'@'localhost'; +----------------------------------------------------------------------------------------------------------------------------------------+ | Grants for root@localhost | +----------------------------------------------------------------------------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '***465FF1427CFDE787DFCD127C494370D51BF00*' WITH GRANT OPTION | +----------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.04 sec)
mysql>
Zamiast localhost wpisz 127.0.0.1 Co pokazuje?
Mowisz i masz :)
mysql> show grants for 'root'@127.0.0.1; +---------------------------------------------------------------------+ | Grants for root@127.0.0.1 | +---------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' WITH GRANT OPTION | +---------------------------------------------------------------------+ 1 row in set (0.00 sec)
Pzdr TD