Manual Installation - creating admin user - joomla docs incomplete
Posted: Mon Feb 13, 2006 1:24 am
Hi
The docs on Joomla manual installation appear to be incorrect and incomplete...
I've done a manual installation using the joomla.sql and sampledata.sql but there is a problem.
It does not appear to create a default admin user or any other default user
...in the docs it says
http://help.joomla.org/content/view/40/168/
You may also use phpmyadmin (a php based, MySQL Administration tool), instead of the command line tools, as this makes dropping the database in quick and easy. Edit the file sql/mambo.sql and uncomment the very last 6 lines of the file starting:
INSERT INTO `mos_users` VALUES (62, 'Administrator'
Import the SQL into your newly created database, from the sql/joomla.sql text file, for example:
mysql -uroot -ppassword joomla_database_name < sql/joomla.sql
But there are no 6 commented lines to create the user in the ' joomla.sql' [that old mambo.sql reference needs to be removed]
And I cannot work out how i should insert that admin user.
Can anybody supply me with the correct sql to insert the default admin user?
I see also after some more searching of the forum that this was a problem back in November 05 and has not been addressed in the docs still.
http://forum.joomla.org/index.php/topic,16703.0.html
with one solution here
http://forum.joomla.org/index.php/topic ... l#msg63069
However it would be good if someone from the documtentation team could add that to either the joomla.sql file directly as a commented out option OR at least update the manual install docs to indicate how to fix it.
thanks
The docs on Joomla manual installation appear to be incorrect and incomplete...
I've done a manual installation using the joomla.sql and sampledata.sql but there is a problem.
It does not appear to create a default admin user or any other default user
...in the docs it says
http://help.joomla.org/content/view/40/168/
You may also use phpmyadmin (a php based, MySQL Administration tool), instead of the command line tools, as this makes dropping the database in quick and easy. Edit the file sql/mambo.sql and uncomment the very last 6 lines of the file starting:
INSERT INTO `mos_users` VALUES (62, 'Administrator'
Import the SQL into your newly created database, from the sql/joomla.sql text file, for example:
mysql -uroot -ppassword joomla_database_name < sql/joomla.sql
But there are no 6 commented lines to create the user in the ' joomla.sql' [that old mambo.sql reference needs to be removed]
And I cannot work out how i should insert that admin user.
Can anybody supply me with the correct sql to insert the default admin user?
I see also after some more searching of the forum that this was a problem back in November 05 and has not been addressed in the docs still.
http://forum.joomla.org/index.php/topic,16703.0.html
with one solution here
http://forum.joomla.org/index.php/topic ... l#msg63069
However it would be good if someone from the documtentation team could add that to either the joomla.sql file directly as a commented out option OR at least update the manual install docs to indicate how to fix it.
thanks