This is simple. After you setup a user with proper access rights run the below commands. # mysql -u yourUser -p -h <yourHostname or IP> A little explanation: -u tells mysql what your username -p tells mysql you have a password and will prompt you to enter it after you press enter -h tells mysql […]
Category Archives: SQL
Difference between Inner Join and Outer Join in SQL
An inner join it is the most common kind of join, so common that SQL doesn’t actually make us say “inner join” to do one. An outer join returns a set of records or rows that include what an inner join would return, but also includes other rows for which no corresponding match is found in the […]