I have two versions of MySQL running on the same machine
Question 1: I have NOT changed my php.ini to reflect any changes, is this necessary?
I am booting using the --old-passwords to remain compatable with the MySQL4 client with a user named mysql5
$ sudo /var/mysql5/bin/mysqld_safe --old-passwords --user=mysql5 &
I am interested in a liberal policy to get SilverStripe installed before I want to deal with security issues. The following outlines what I have done for a test installation. The following reflects the minimum permission settings required to get me past all the portions of the install.php (except the database details).
I have an OpenBSD machine running
Apache/1.3.29 (Unix) PHP/5.0.4 mod_ssl/2.8.16 OpenSSL/0.9.7g
with MySQL 4.0.24 and MySQL 5.0.27
I have created and altered the /etc/my.cnf file to use port 3666 for MySQL 5 and ensured that the file my.cnf is owned by mysql5
chown mysql5 my.cnf
--------------------
# The MySQL client
port = 3666
socket = /tmp/mysql.sock
# The MySQL server
[mysqld]
old-passwords
port = 3666
socket = /tmp/mysql.sock
---------------------
// I have liberal folder permission settings
//Get a copy of silverstripe-v2.0.0.tar.gz onto your server and extract it
$tar zxvf silverstripe-v2.0.0.tar.gz
//Change the ownership to the username that owns htdocs.
#chown -R username silverstripe-v2.0.0
//Make the folder 'silverstripe-v2.0.0.0' global read /write /execute
#chmod 777 silverstripe-v2.0
//Make the folder 'silverstripe-v2.0.0.0/mysite' global read /write
#chmod 776 silverstripe-v2.0.0.0/mysite
Create a temporary directory named adfadsfdas
# mkdir adfadsfdas
//change ownership to your silverstripe user
# chown username adfadsfdas
//Make the temporary folder global read /write/ execute
# chmod 777 adfadsfdas
//Create a MySQL User and Database
I have created a new MySQL5 root powered user and a database using the following
--------------------
MySQL>GRANT USAGE ON * . * TO 'StripeUSER2'@'localhost' IDENTIFIED BY 'password' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ;
// give StripeUSER2 access to all databases
mysql> GRANT ALL PRIVILEGES ON *.* TO 'StripeUSER2'@'localhost'
-> IDENTIFIED BY 'passwordheret' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)
// redundant give privilege to StripeDATA2 to StripeUSER2
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
-> ON StripeDATA2.*
-> TO 'StripeUSER2'@'localhost'
-> IDENTIFIED BY 'anarchy4breakfast';
Query OK, 0 rows affected (0.01 sec)
mysql>FLUSH PRIVILEGES;
------------------------------------------------------------
// Then with the data entered into install.php for the database as:
MySQL server:localhost:3666
MySQL username:StripeUSER2
MySQL password:password
MySQL database:StripeDATA2
// the following messages appear
Does the server exist OK (localhost:3666)
Are the access credentials correct
That username/password doesn't work: Access denied for user: 'StripeUSER2@localhost' (Using password: YES)
Can I access/create the database
I can't create new databases and the database 'StripeDATA2' doesn't exist (user 'StripeUSER2' doesn't have CREATE DATABASE permissions.)
Where am I going wrong? Wrong method of accessing non-standard port?
unknown php.ini setting for non-standard port? What am I not seeing?