Search
 
SCRIPT & CODE EXAMPLE
 

SQL

mysql allow connection from any host

GRANT ALL ON yourdatabasename.* TO root@'%' IDENTIFIED BY
'yourRootPassword';
Comment

mysql allow connection from any host

GRANT ALL ON database_name.* TO user_name@'ip_address' IDENTIFIED BY 'user_password';
Comment

mysql allow connection from any host

GRANT ALL ON mydatabase.* TO myuser@'%' IDENTIFIED BY 'mypassword';
GRANT ALL ON *.* TO myuser@'%' IDENTIFIED BY 'mypassword';
Comment

PREVIOUS NEXT
Code Example
Sql :: how to install mssql on mac 
Sql :: substract variable amount of minutes from timestamp postgresql 
Sql :: query only first letter string 
Sql :: clone row from another table mysql 
Sql :: mysql select random rows large table 
Sql :: MySQL error code 2068 
Sql :: sql cross apply vs join 
Sql :: mysql multiply 
Sql :: sql recherche nom prenom 
Sql :: mysql update LAST_INSERT_ID() 
Sql :: what are the data types in sql 
Sql :: cast in sql server 
Sql :: SQL Addition Operator 
Sql :: last mysql 
Sql :: join with multiple conditions sql 
Sql :: psql view databases 
Sql :: mysql workbench primary key 
Sql :: sql transaction 
Sql :: stuff in sql 
Sql :: new rails app with mysql 
Sql :: what is ssrs and ssis in sql server 
Sql :: postgresql cast string to int 
Sql :: mov volume before build 
Sql :: in subquery terminology, the first query in the sql statement is known as the _____ query. 
Sql :: delete from table and truncate table 
Sql :: mysql command line top 10 
Sql :: sqldf change user 
Sql :: create backup 
Sql :: sql eomonth(getdate) 
Sql :: second highest salary in mysql 
ADD CONTENT
Topic
Content
Source link
Name
1+9 =