loguję sie na root - dowód
C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql.exe Ver 8.0.12 for Win64 on x86_64 (MySQL Community Server - GPL)
Connection id: 69
Current database:
Current user: root@localhost
SSL: Cipher in use is DHE-RSA-AES128-GCM-SHA256
Using delimiter: ;
Server version: 8.0.12 MySQL Community Server - GPL
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: cp852
Conn. characterset: cp852
TCP port: 3306
Uptime: 8 hours 17 min 59 sec
Threads: 2 Questions: 4701 Slow queries: 0 Opens: 673 Flush tables: 2 Open tables: 649 Queries per second avg: 0.157
--------------
Chcę nadać hasło użytkownikowi, lecz nie mogę:
mysql> SET PASSWORD FOR '244951'@'localhost' = PASSWORD('cokolwiek');
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PASSWORD('cokolwiek')' at line 1
próbuję nadać prawa użytkownikowi lecz:
grant select ,alter ,insert on `laboratorium-filmoteka`.* to '244951';
[2018-10-28 15:58:38] [42000][1410] You are not allowed to create a user with GRANT
Sprawdzam więc ustawienia root'a:
*************************** 1. row *************
Host: localhost
User: root
Select_priv: Y
Insert_priv: Y
Update_priv: Y
Delete_priv: Y
Create_priv: Y
Drop_priv: Y
Reload_priv: Y
Shutdown_priv: Y
Process_priv: Y
File_priv: Y
Grant_priv: Y
References_priv: Y
Index_priv: Y
Alter_priv: Y
Show_db_priv: Y
Super_priv: Y
Create_tmp_table_priv: Y
Lock_tables_priv: Y
Execute_priv: Y
Repl_slave_priv: Y
Repl_client_priv: Y
Create_view_priv: Y
Show_view_priv: Y
Create_routine_priv: Y
Alter_routine_priv: Y
Create_user_priv: Y
Event_priv: Y
Trigger_priv: Y
Create_tablespace_priv: Y
Co robię źle ? ;)