How to add User in MySQL?

To add super user in MySQL with the username "gep", put the following two commands at prompt

GRANT ALL PRIVILEGES ON *.* TO gep@localhost IDENTIFIED BY ‘password‘ WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO gep@"%" IDENTIFIED BY ‘password‘ WITH GRANT OPTION;

See also http://dev.mysql.com/doc/refman/4.1/en/grant.html

Posted: July 24, 2007 Comments (0)

Wiki Installation Note

Wiki name: Engineering Dictionery
Contact e-mail: ito@isidsea.com
Language: en - English
Copyright/license: No license metadata
Admin username: wikisid
Password: ********
Password confirm: ********
Shared memory caching: No caching
Memcached servers:

E-mail: Enabled
User-to-user e-mail: Enabled
E-mail notification: Enabled for user_talk and watch list changes (not recommended for large wikis)
E-mail authentiction: Enabled

Database type: MySQL
SQL server host: localhost
Database name: wikidb
DB username: gep
DB password: ********
DB password confirm: ********
Database table prefix: mw_
Database charset: Backwards-compatible UTF-8

Superuser account: root
Superuser password:

Posted: Comments (0)

Enabling InnoDB on IIS

Incoming further disturbance, was occurred during Mediwwiki installation on a halfway, and it was:

The ‘InnoDB’ feature is disabled; you need MySQL built with ‘InnoDB’ to have it working

  1. Shut down your MySQL server (stop the service)
  2. Open my.ini (mysql’s config file), which is located in your MySQL program folder.
  3. In my.ini, find the following:
     skip-innodb
  4. Replace this line(uncomment) with:
     # skip-innodb
  5. Save the file
  6. Start the MySQL server again

After doing aboves, installation was successfully completed, and the case is closed…

Posted: Comments (0)

Path problem in php.ini

I have checked all those MySQL and PHP operation as well as Mediawiki placement, and have attempted "click here" below the sunflower, I’m faced with  the following bug despite a lot of checking with uncommenting "extension=php_mysql.dll" at php.ini

PHP 5.2.0 installed Could not find a suitable database driver!
For MySQL, compile PHP using –with-mysql, or install the mysql.so module
For PostgreSQL, compile PHP using –with-pgsql, or install the pgsql.so module

After much trial and error, I changed the extension_dir parameter in "php.ini" to point to "c:\php\ext" from just "./" and finally mediawiki installation form turned up at …wiki/index.php

Posted: Comments (0)