Bugzilla:Win32Install: Difference between revisions

Jump to navigation Jump to search
→‎Create Bugs Database and User: You shouldn't be creating the DB manually--checksetup does that for you.
(Reverting the last few changes. Useless and confusing information has been added by some contributors)
(→‎Create Bugs Database and User: You shouldn't be creating the DB manually--checksetup does that for you.)
Line 93: Line 93:
MySQL has a standard Windows installer.  It's ok to select a Typical MySQL install (the default).  For the remainder of this document I will assume you have installed MySQL into <b>C:\mysql</b>.
MySQL has a standard Windows installer.  It's ok to select a Typical MySQL install (the default).  For the remainder of this document I will assume you have installed MySQL into <b>C:\mysql</b>.


====Create Bugs Database and User====
====Create Bugs Database User====


Use the <b>mysql</b> command line utility to create the Bugzilla database and a MySQL account for Bugzilla.
Use the <b>mysql</b> command line utility to create a MySQL account for Bugzilla.


Note in the following example 'sockmonkey' is my password for the bugs account:
Note in the following example 'sockmonkey' is my password for the bugs account:
Line 107: Line 107:
  Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
  Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
   
   
  mysql&gt; <b>create database bugs;</b>
  mysql&gt; <b>GRANT ALL PRIVILEGES ON bugs.* TO 'bugs'@'localhost' IDENTIFIED BY 'sockmonkey';</b>
Query OK, 1 row affected (0.11 sec)
mysql&gt; <b>grant all privileges on bugs.* to 'bugs'@'localhost' identified by 'sockmonkey';</b>
  Query OK, 0 rows affected (0.03 sec)
  Query OK, 0 rows affected (0.03 sec)
mysql&gt; <b>flush privileges;</b>
Query OK, 0 rows affected (0.00 sec)
   
   
  mysql&gt; <b>quit</b>
  mysql&gt; <b>quit</b>
canmove, Confirmed users
345

edits

Navigation menu