DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(mysql.info) windows-post-installation

Info Catalog (mysql.info) post-installation (mysql.info) post-installation (mysql.info) unix-post-installation
 
 2.9.1 Windows Post-Installation Procedures
 ------------------------------------------
 
 On Windows, the data directory and the grant tables do not have to be
 created. MySQL Windows distributions include the grant tables with a
 set of preinitialized accounts in the `mysql' database under the data
 directory. It is unnecessary to run the `mysql_install_db' script that
 is used on Unix. Regarding passwords, if you installed MySQL using the
 Windows Installation Wizard, you may have already assigned passwords to
 the accounts. (See  windows-install-wizard.) Otherwise, use the
 password-assignment procedure given in  default-privileges.
 
 Before setting up passwords, you might want to try running some client
 programs to make sure that you can connect to the server and that it is
 operating properly. Make sure that the server is running (see 
 windows-server-first-start), and then issue the following commands to
 verify that you can retrieve information from the server. The output
 should be similar to what is shown here:
 
      C:\> C:\mysql\bin\mysqlshow
      +-----------+
      | Databases |
      +-----------+
      | mysql     |
      | test      |
      +-----------+
 
      C:\> C:\mysql\bin\mysqlshow mysql
      Database: mysql
      +---------------------------+
      |          Tables           |
      +---------------------------+
      | columns_priv              |
      | db                        |
      | func                      |
      | help_category             |
      | help_keyword              |
      | help_relation             |
      | help_topic                |
      | host                      |
      | proc                      |
      | procs_priv                |
      | tables_priv               |
      | time_zone                 |
      | time_zone_leap_second     |
      | time_zone_name            |
      | time_zone_transition      |
      | time_zone_transition_type |
      | user                      |
      +---------------------------+
 
      C:\> C:\mysql\bin\mysql -e "SELECT Host,Db,User FROM db" mysql
      +------+-------+------+
      | host | db    | user |
      +------+-------+------+
      | %    | test% |      |
      +------+-------+------+
 
 If you are running a version of Windows that supports services and you
 want the MySQL server to run automatically when Windows starts, see
  windows-start-service.
 
Info Catalog (mysql.info) post-installation (mysql.info) post-installation (mysql.info) unix-post-installation
automatically generated byinfo2html