3 replies to this topic

[Mooey]

Right, because my workplace host is crud i cant add a user name to a database via Cpanel. On my host its dead easy.

I've created the database (dbjoomla), rather than add a user name with a password easy, you have to click a link then it goes to (phpMyAdmin).

I'm stuck, I dont know how to add a username. Need to create one before I can carry on with the installation of Joomla.

Help PLEASE!!!

[coolaid]

well you'd have to create a table named something like 'users' with the AT LEAST the two columns 'name' and 'password'

[Stu]

i think he means his host does not allow him to add an actual username to the database in order to access it.

if im right in thinking the abovve hopefully these 3 links will help (more specifically the last two):

http://dev.mysql.com...ding-users.html
http://dev.mysql.com...reate-user.html
http://dev.mysql.com...0/en/grant.html

i think you would do a query something like

INSERT INTO mysql.user (user, host, password) VALUES ('user', 'localhost', PASSWORD('pass'));

GRANT ALL PRIVELAGES ON database TO user@localhost IDENTIFIED BY 'pass';

FLUSH PRIVILEGES;

i think you would skip the first bit if you already have an actual user created but just not added to the database too...

feel welcome to wait for someone else to answer though, cus i have never done it before and i dont know if its right

Edited by Stu, 15 March 2006 - 12:54 PM.

[Mooey]

Thanks for the replys lads, this database lark is giving me grey hairs

Stu - cheers for the links