StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>as others have already asked, i am not sure what you are trying to achieve.</p> <p>I used encryption(loosely used) if someone who you suspect might be accessing info or databases they are not supposed to view. If it helps, you could grant privileges to users to access specific databases within mysql.</p> <p>Normally if your mysql is a new install you can login to it by doing this:</p> <pre><code>mysql -u root -p </code></pre> <p>and then press enter without typing a password then it logs you into mysql </p> <pre><code>mysql> </code></pre> <p>Lets assume we have a database called "chicken_farm_development" and we want to grant access to the user "farmer_brown"</p> <p>Then we could grant privileges to "famer_brown" to only access "chicken_farm_development" database and nothing else in mysql(so farmer_brown cannot access "joes_pizza_development" database). We do this in mysql:</p> <pre><code>mysql> GRANT ALL PRIVILEGES ON chicken_farm_development.* -> TO 'farmer_brown'@'localhost' -> IDENTIFIED BY 'mysecretpassword'; </code></pre> <p>To check that this works:</p> <pre><code>mysql> SHOW GRANTS FOR 'farmer_brown'@'localhost'; </code></pre> <p>and it should display the grants for farmer_brown.<br /> So how can you use this? Not really sure how thinking sphinx is setup, but you could grant access for thinking sphinx to use a specific database, without affecting any other databases you might have, and can be extrapolated to production environments.</p> <p>to login to mysql as farmer_brown, you would do this:</p> <pre><code>$ mysql -u farmer_brown -p chicken_farm_development Enter password: </code></pre> <p>and whooohooo!, farmer brown now only has access to chicken_cms_developement database. In summary you can grant access to specific databases. Hope this helps a little as it was a bit unclear as to what you were asking.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload