Changing host permissions for MySQL USERS

 If you've got access to the mysql database, you can change the grant tables directly:

UPDATE mysql.user SET Host='%' WHERE Host='localhost' AND User='username';

...and an analogous UPDATE-statement to change it back.

Also you might need to make changes to the mysql.db table as well:

UPDATE mysql.db SET Host='%' WHERE Host='localhost' AND User='username';

and then flush to apply the privileges:

FLUSH PRIVILEGES;

Comments

Post a Comment

Popular posts from this blog

simple inventory management system using Google Apps Script

Here is a source code for a simple inventory management system using Google Apps Script: function checkInventory() {   var sheet = SpreadsheetApp.getActiveSheet();   var data = sheet.getDataRange().getValues();      var message = "Inventory:\n";      for (var i = 1; i < data.length; i++) {     var item = data[i][0];     var quantity = data[i][1];     message += item + ": " + quantity + "\n";   }      Browser.msgBox(message); } function updateInventory(item, amount) {   var sheet = SpreadsheetApp.getActiveSheet();   var data = sheet.getDataRange().getValues();      for (var i = 1; i < data.length; i++) {     if (data[i][0] == item) {       var newQuantity = parseInt(data[i][1]) + amount;       sheet.getRange(i+1, 2).setValue(newQuantity);       break;     }   } } function submitForm(e) {   var i...
Read more

How to Debug Android TV App using IP

How to Connect Android TV to Your PC Using ADB Normally, we use a USB cable to connect a PC with an Android. Since this is not feasible with Android TVs, manufacturers allow you to  set up ADB wirelessly . To do that: On your Android TV, go to  Settings > Device Preferences > About > Status  and note down the  IP address . Open the command prompt on your PC and enter the command  adb connect <the IP address> . tiny adb on desktop enter ip address You will get a prompt on your Android TV asking you to authorize a connection to the computer. Tap on  OK . To check if you have successfully established the ADB connection to your Android TV, enter the command  adb devices  and see if the device shows up under  List of devices attached . Source:  https://www.makeuseof.com/how-to-use-adb-on-android-tv/
Read more

How to Safely Delete Files and Directories Using Linux Command Line

  In this tutorial we can check how to safely delete files and directories using Linux Command line To remove a file or directory in Linux, we can use the rm command or unlink command. The rm command removes each specified file. By default, it does not remove directories. Also, it does not work on directories that contain files. The rm command (short for remove) is a Unix / Linux command which is used to delete files from a file system. Usually, on most filesystems, deleting a file requires write permission on the parent directory (and execute permission, in order to enter the directory in the first place). Also, be careful with the rm command because it does not ask you for confirmation when deleting files. Be sure you really want to delete your files before you use  rm , because once the files are gone, they’re not coming back. The multi-user nature of Linux does not allow for file recovery as in DOS. As soon as you let go of the space occupied by a file, the operating syste...
Read more