76 reputation
6
bio website rondarchief.nl
location Netherlands
age
visits member for 2 years
seen Sep 4 at 17:30

Jun
23
awarded  Autobiographer
Jun
23
awarded  Informed
Mar
5
awarded  Supporter
Dec
10
comment using virtual machine like mySql server
Well, in order to clean the GRANT's we've been adding you could do REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'root'@'192.168.1.77'. It's probably the multiple access definitions with/without password that are clogging your access table now. If you have a commandline mysql terminal open, you can issue SELECT user,host FROM mysql.user; and then check SHOW GRANTS FOR 'root'@'localhost'; for each 'user'@'host' (sadly there is no show-all).
Dec
10
comment using virtual machine like mySql server
You could add the GRANT to 'root'@'192.168.%', where % is a wildcard. :-)
Dec
10
comment using virtual machine like mySql server
Try executing your script without a password. There was no password associated with the root user for this IP. So MySQL hasn't allocated one with the GRANT. You can also use this with your password: GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.77' IDENTIFIED BY 'your_password';
Dec
10
comment using virtual machine like mySql server
You'll need to add correct permissions for the user you're connecting as. If you're connecting as user "root", that would be something like this: GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.77';. You'll need to execute this locally on your ubuntu VM, so in terminal connect with mysql -u root -p and execute it there.
Dec
10
answered using virtual machine like mySql server
Oct
1
awarded  Revival
Sep
20
awarded  Teacher
Sep
12
awarded  Analytical
Sep
12
answered Difference between ps output and top output?