Create Users Table Without Shell Access

mysql and phpmyadmin

[ukgimp]

Hello

I have mysql and php running fine along with mysql. Unfortunatly there are no user proviledges set up. I dont have shell access. Can the security settings be done with phpmyadmin.

I do have to give a password to enter phpmyadmin along with hte folder being htaccessed out but I want to create the high level security that I know is available.

Cheers as always

[justageek]

Cheers....I use the mcc. Works good.

JAG

[lorax]

>> Can the security settings be done with phpmyadmin.

Security for what exactly? Your scripts, your database, or?

[ukgimp]

to set up the privileges for the database itself, before any scripts are even launched.

To do stuff like

% mysql -u root mysql

Cheers

[lorax]

Hoo boy. I don't think you can setup permissions on the database without access to shell. Does your host have a control panel that offers some tools for working with the database?

[ukgimp]

I setup phpmyadmin, no problem. I then had not passwords or anything. Not even permissions to to add a new database. I asked them about ti. They dropped a mysql table on there somewhere and it appears to be fine now. I must admit I would like to know how to do it for future use.