Here’s the syntax to add a user to MySQL:
|
1 2 3 4 5 6 |
<pre class="code"> GRANT ALL PRIVILEGES ON *.* TO 'user'@'localhost' IDENTIFIED BY 'some_pass' WITH GRANT OPTION; <pre class="code"> |
I always have trouble keeping the different types of SQL joins straight in my head so here is a quick reference: Inner Join – An inner join returns only those records from both tables that have a matching value in the related field. In other words only those records that satisfy the join condition. Outer Joins – Outer joins return records from one table where there are no matching records in the other table. There are three types of outer joins – left outer, right outer, full outer. Left Outer Join – The left outer join retrieves records from both tables, retrieving all the records from the left table and any records from the right table where the condition values match. If there are no matching values in from the right table, the join still retrieves all the records from the left table. Any columns from the right table that
Here’s a link to the instruction on how to reset a lost root password for mysql: http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
Here’s a sql query to set the auto_increment counter:
|
1 2 |
ALTER TABLE theTableInQuestion AUTO_INCREMENT=1234 |
http://dev.mysql.com/doc/mysql/en/Slow_query_log.html Add the following options to mysqld command line:
|
1 |
--log-slow-queries --log-long-format |
Reliable Penguin provides managed web hosting, systems administration, website and server migrations, and expert consulting.
Submit the form—or for immediate service call 866-649-7984.