Search the Community
Showing results for tags 'mysql'.
Found 2 results
-
Global Privileges Global privileges are administrative or apply to all databases on a given server. To assign global privileges, use ON *.* syntax: GRANT ALL ON *.* TO 'SomeMysqlUser'@'somehost'; or GRANT ALL PRIVILEGES ON *.* TO 'YourMysqlUserName'@'YourIP' IDENTIFIED BY "YourMysqlPassword"; Example: GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY "*****"; __________________________________________
-
Start MySQL 5.5 Command Line ClientAt the command prompt, execute the foll. command mysql> show variables like 'max_allowed_packet'; At the command prompt, execute the foll. command mysql> set global max_allowed_packet = 130 * 1024 * 1024; ExitStart MySQL 5.5 Command Line ClientAt the command prompt, execute the foll. command mysql> show variables like 'max_allowed_packet'; This will set the global max packet size to 130 MB. All subsequent MySQL client connections will get this value as their session value for max packet Now: Source Database : information_schema `GLOBAL_VARIABLES` VALUES ('MAX_ALLOWED_PACKET', '136314880');
