MySql Configuration

MySQL CONNANDS :-

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'PASSWARD';
     //for getting permission for remote access

sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
sudo ufw allow 3306/tcp
sudo service ufw restart 
sudo service mysql restart
sudo mysql
select user, authentication_string, plugin, host from mysql.user;
control+c for exit
 

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

create a CRUD web application with Google Apps Script

  To create a CRUD web application with Google Apps Script, we will use Google Sheets as our database and build a web interface using HTML and JavaScript. Here is an example code for a basic CRUD web application: Step 1: Create a new Google Sheet To begin, open a new Google Sheet and give it a name. This sheet will serve as the database for our CRUD application. In the first row, add the following headers: "ID", "Name", "Email", "Phone". Step 2: Create a new Google Apps Script Next, click on "Tools" in the menu bar and select "Script editor". This will open the Google Apps Script editor. In the editor, create a new script file and give it a name. Step 3: Create the HTML interface In the script editor, create a new HTML file by clicking on "File" -> "New" -> "Html file". Name the file "index". In this file, we will create the interface for our CRUD application. Here is an example co...
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