[Pytanie] z komenda do dodania usera 'mt2'@'localhost'

[Pijoczek]

Siema.

Mam problem z komendą na dodanie usera 'mt2'@'localhost' po wpisaniu komendy CREATE USER 'mt2'@'localhost' IDENTIFIED BY 'mt2!@#'; wyskakuje mi

 

mysql> CREATE USER 'mt2'@'localhost' IDENTIFIED BY 'mt2!@#';

ERROR 1396 (HY000): Operation CREATE USER failed for 'mt2'@'localhost'

 

Ps. serwer jest robiony na dedyku.

[BloodSmokers]

Po co komu dedyk skoro nie umie nawet usera dodać, google nie gryzie, na youtubie masz opór takich poradników.

[Pijoczek]

Tak próbowałem wielu poradników resetowałem hasło ale nic nie dało a skoro nic nie wnosisz do tematu to po cos piszesz?

[Blessik]

@BloodSmokers

 

Jeśli takie poradniki są to je tu podaj a nie pouczasz kogoś by nie stawiał dedyka... Nie do tego jest ten temat , a jeżeli ty jesteś tak wszystko wszechwiedzący to to wytłumacz bo do tematu nic nie wniosłeś :<

[Pijoczek]

po próbie dodania tego uzytkownika mam takie cos

 

mysql> CREATE USER 'root'@'%' IDENTIFIED BY 'tutaj moje hasło';

ERROR 1396 (HY000): Operation CREATE USER failed for 'root'@'%'

[SuicideRlz]

SHOW GRANTS;

Podaj output tutaj.

[Pijoczek]

Z kąd mam to wziąść? :P

 

po wpisaniu komendy mysql mam takie cos

 

ks383816# mysql

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

[Pijoczek]

SHOW GRANTS;

Podaj output tutaj.

 

 

Wpisałem to i mam takie coś

 

mysql> SHOW GRANTS;

+---------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------+

| Grants for root@localhost |

+---------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------+

| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREA TE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO 'root'@'localhost' IDENT IFIED BY PASSWORD '*839E2E02728DFBA36C0389417509643BFCA1F91C' WITH GRANT OPTION |

| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION |

+---------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------+

2 rows in set (0.00 sec)

mysql> SHOW GRANTS;

+---------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------+

| Grants for root@localhost |

+---------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------+

| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREA TE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO 'root'@'localhost' IDENT IFIED BY PASSWORD '*839E2E02728DFBA36C0389417509643BFCA1F91C' WITH GRANT OPTION |

| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION |

+---------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------+

2 rows in set (0.00 sec)

mysql> SHOW GRANTS;

+---------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------+

| Grants for root@localhost |

+---------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------+

| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREA TE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO 'root'@'localhost' IDENT IFIED BY PASSWORD '*839E2E02728DFBA36C0389417509643BFCA1F91C' WITH GRANT OPTION |

| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION |

+---------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------+

2 rows in set (0.00 sec)

 

 

po wpisaniu komendy na start serwera wszystko idzie tylko pod koniec blad taki mam jak na ss

 

 

[boooooo]

Zrób tak :

 

 CREATE USER 'root'@'%' INDENTIFIED BY 'hasło' ; 

[SuicideRlz]

Twoje hasło to zaq12wsx, zmień je (po wpisaniu tego na dole) i następnym razem nie podawaj hashy.

W konsoli wpisz: mysql -pzaq12wsx < "CREATE USER 'mt2'@'localhost' IDENTIFIED BY 'mt2!@#'; GRANT ALL PRIVILEGES ON *.* TO 'mt2'@'localhost';"

[Pijoczek]

Okej dzieki

[michal3433]

Witam mam taki sam problem pomóżcie !