I keep on getting access denied during moodle installation. can anyone advise please?
see error below:
1044: Access denied for user 'testuser'@'localhost' to database 'test'
AA,
According to the docs (http://docs.moodle.org/en/Installing_Moodle#Using_a_hosted_server or http://docs.moodle.org/en/Installing_Moodle#Using_the_command_line as the case may be), when you create the database user for Moodle to use for database access, you need to grant that user all rights to that database, including index.
RLE
Hi,
I tried to config moodle by command line, but i still had some this error, i don't know how to do hic hic.
Moodle Version: 1.8.3,
Mysql: 5.0 Alpha,
PHP: 4.41,
Apache: 2.0.55.
Who can help me????
1071: Specified key was too long. Max key length is 500
adodb_mysql._execute(CREATE INDEX mdl_glosentr_con_ix ON mdl_glossary_entries (concept), false) % line 889, file: adodb.inc.php
adodb_mysql.execute(CREATE INDEX mdl_glosentr_con_ix ON mdl_glossary_entries (concept)) % line 89, file: dmllib.php
execute_sql(CREATE INDEX mdl_glosentr_con_ix ON mdl_glossary_entries (concept), true) % line 1911, file: dmllib.php
execute_sql_arr(Array[42]) % line 548, file: ddllib.php
install_from_xmldb_file(D:\www\moodle-1.8.3/mod/glossary/db/install.xml) % line 328, file: adminlib.php
I tried to config moodle by command line, but i still had some this error, i don't know how to do hic hic.
Moodle Version: 1.8.3,
Mysql: 5.0 Alpha,
PHP: 4.41,
Apache: 2.0.55.
Who can help me????
1071: Specified key was too long. Max key length is 500
adodb_mysql._execute(CREATE INDEX mdl_glosentr_con_ix ON mdl_glossary_entries (concept), false) % line 889, file: adodb.inc.php
adodb_mysql.execute(CREATE INDEX mdl_glosentr_con_ix ON mdl_glossary_entries (concept)) % line 89, file: dmllib.php
execute_sql(CREATE INDEX mdl_glosentr_con_ix ON mdl_glossary_entries (concept), true) % line 1911, file: dmllib.php
execute_sql_arr(Array[42]) % line 548, file: ddllib.php
install_from_xmldb_file(D:\www\moodle-1.8.3/mod/glossary/db/install.xml) % line 328, file: adminlib.php
LH,
In researching this issue I have found that the error you got, which is a MySQL error, has come up over and over again for the last four years, both in this forum and the Tracker, especially among users of the Vietnamese and Japanese languages, probably because they use more bytes per character than European languages in UTF8. What puzzles me most is that in the references I looked at it was stated that the latest versions of MySQL have a 1000 byte limit, not 500, as the older versions did. The docs specify to use MySQL version 4.1.16 or higher; you are using 5.0, yet you are running into the 500 byte limit. The only later version I am aware of is 5.1.
So my suggestions are:
- Try MySQL 5.1 and see if it doesn't have a 1000 byte limit, and see if that does not solve your problem.
- If not, create a new tracker issue. Mention the latest tracker issue on this error, which was closed (as fixed!) about three weeks ago: http://tracker.moodle.org/browse/MDL-11555. Also mention your forum post (http://moodle.org/mod/forum/discuss.php?d=83013#p367199), and that it shows that the problem is not fixed.
RLE