unable to connect to localhost mysql workbench

 # open mysql conf file

sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf


# replace bind-address from 127.0.0.1 to 0.0.0.0

"""


bind-address            = 0.0.0.0


"""

# login to mysql

sudo mysql


# create a Database

CREATE DATABASE db_name;


# allow a full access to a specific user for a specific db

GRANT ALL ON db_name.* TO user_name@'%' IDENTIFIED BY 'user_password';

GRANT ALL PRIVILEGES ON db_name.* TO 'user'@'hostname' ; # when password is already created 


# exit mysql

exit


# open up port 3306 for every one

sudo ufw allow 3306


# restart mysql

sudo systemctl restart mysql


# check from some external client to connect to this mysql. it should be successful



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

sales forecasting ML model in retail using the Prophet algorithm from the Facebook Prophet library

sales forecasting ML model in retail using the Prophet algorithm from the Facebook Prophet library: import pandas as pd from fbprophet import Prophet # Load the sales data into a pandas dataframe sales_data = pd.read_csv('sales_data.csv') # Convert the date column to a pandas datetime object sales_data['date'] = pd.to_datetime(sales_data['date']) # Rename the columns to 'ds' and 'y' for Prophet compatibility sales_data = sales_data.rename(columns={'date': 'ds', 'sales': 'y'}) # Create and train the Prophet model model = Prophet() model.fit(sales_data) # Create a future dataframe for the next 30 days future = model.make_future_dataframe(periods=30) # Make sales predictions for the next 30 days sales_predictions = model.predict(future) # Print the sales predictions for the next 30 days print(sales_predictions.tail(30)) In this code, we first load the sales data into a pandas dataframe and convert the date column to a...
Read more

static file does not load in nginx on ubuntu server

Nginx serve static file and got 403 forbidden  Just want to help somebody out. yes ,you just want to serve static file using nginx, and you got everything right in   nginx.conf : location /static { autoindex on; #root /root/downloads/boxes/; alias /root/downloads/boxes/; } But , in the end , you failed. You got "403 forbidden" from browser... ---------------------------------------- The Answer Below: ---------------------------------------- The Solution is very Simple: Way 1 : Run nginx as the user as the '/root/downloads/boxes/' owner In  nginx.conf  : ＃user nobody; worker_processes 1; #error_log logs/error.log; #error_log logs/error.log notice; YES, in the first line " ＃user noboy; " , just delete " # " , and change " nobody " to your own username in Linux/OS X, i.e change to " root " for test. The restart nginx. reference by -https://stackoverflow.com/questions/16808813/nginx-serve-static-file...
Read more