1,478
edits
MySQL Console: Difference between revisions
m
no edit summary
m (Fixed link to New Users: Security) |
mNo edit summary |
||
| Line 1: | Line 1: | ||
{{Uc nav mysql}} | |||
{ | |||
'''MySQL creating users and setting permissions using MySQL console''' | '''MySQL creating users and setting permissions using MySQL console''' | ||
MySQL is a multi-user database, you can set up several different accounts on the same server with many varied permissions given to each user. This ability is part of what makes MySQL so powerful. You can use either MySQL console or phpMyAdmin to create users and grant permissions. This page focuses on using MySQL console. Not intended as a definitive guide but more of an introduction to show you how to access and run MySQL console within the UniServer environment. | MySQL is a multi-user database, you can set up several different accounts on the same server with many varied permissions given to each user. This ability is part of what makes MySQL so powerful. You can use either MySQL console or phpMyAdmin to create users and grant permissions. This page focuses on using MySQL console. Not intended as a definitive guide but more of an introduction to show you how to access and run MySQL console within the UniServer environment. | ||
== MySQL Privileges == | == MySQL Privileges == | ||
| Line 25: | Line 11: | ||
MySQL console is an integral application of MYSQL you run this application from a command prompt on the machine that is running your MySQL server. | MySQL console is an integral application of MYSQL you run this application from a command prompt on the machine that is running your MySQL server. | ||
I have assumed you are using Uniform Server defaults that is '''drive W''' and MySQL user '''name=root''' and '''password=root'''. (Important before going live remember to change your '''[[New Users | I have assumed you are using Uniform Server defaults that is '''drive W''' and MySQL user '''name=root''' and '''password=root'''. (Important before going live remember to change your '''[[New Users Security#MySQL Server Configuration | MySQL root password ]]''') | ||
With both Apache and MySQL, servers running start a command window and navigate to where mysql.exe is located. | With both Apache and MySQL, servers running start a command window and navigate to where mysql.exe is located. | ||
| Line 181: | Line 167: | ||
| [[Image:uc_small_logo.gif]] || [[User:Ric|Ric]] | | [[Image:uc_small_logo.gif]] || [[User:Ric|Ric]] | ||
|} | |} | ||
[[Category: UniCenter]] | [[Category: UniCenter]] | ||
[[Category: MySQL]] | [[Category: MySQL]] | ||