ubuntu mysql cannot connect to database server remote 1

ubuntu mysql cannot connect to database server remote

ByAnurag batra 
1. sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
2. Press CTRL + W and search for bind-address
3. comment out the line by adding # before
4. save the file
5. sudo service mysql restart

Here is what the above code is Doing:
1. We’re importing the mysql.connector library.
2. We’re creating a connection to the database.
3. We’re creating a cursor object.
4. We’re executing a query.
5. We’re fetching the results of the query.
6. We’re printing the results.
7. We’re closing the connection.

Similar Posts

python sql passer des parametres dans une requet pymysql

python sql passer des parametres dans une requet pymysql

ByAnurag batra

# Connect to db # Open a cursor stmt = “SELECT * FROM users WHERE username = %(user)s” cursor.execute(stmt, {“user”: “bob”}) user = cursor.fetchone() print user {“username”: “bob”, “alias”: “bobby”, “avatar”: “default”, “fullname”: “bob”} Here is what the above code is Doing: 1. We’re using the execute method on the cursor object to execute a…

merge clause with inner join

merge clause with inner join

ByAnurag batra

MERGE table1 USING (SELECT table3.keycolumn, table2.DataColumn1, table2.DataColumn2 FROM table2 INNER JOIN table3 ON table2.anotherKey = table3.anotherKey WHERE table2.anotherKey = ‘A1′) tmpTable ON table1.keyColumn = tmpTable.keyColumn WHEN MATCHED THEN UPDATE SET table1.DataColumn1 = tmpTable.DataColumn1 ,table1.DataColumn2 = tmpTable.DataColumn2; Here is what the above code is Doing: 1. It’s creating a temporary table that contains the data you…

how to get table id sequence postgres

how to get table id sequence postgres

ByAnurag batra

SELECT table_name, column_name, column_default from information_schema.columns where table_name=’testing’; Here is what the above code is Doing: 1. We’re using the `.read_sql()` method to read the results of the SQL query into a dataframe. 2. We’re using the `.execute()` method to execute the SQL query. 3. We’re using the `.fetchall()` method to fetch all the results…