Koozali.org: home of the SME Server

Obsolete Releases => SME 7.x Contribs => Topic started by: futureng on May 30, 2008, 08:11:39 PM

Title: Phpmyadmin multiuser doesnt work ??
Post by: futureng on May 30, 2008, 08:11:39 PM

i am using SME 7.3.
i installed phpmyadmin on "http://www.vanhees.cc/index.php?name=CmodsDownload&file=index&req=getit&lid=296"
and  i do step on "http://wiki.contribs.org/Phpmyadminmulti"
But  doesnt work. Only login with "admin" user. i dont understand. help me pls. Thank you.

Title: Re: Phpmyadmin multiuser doesnt work ??
Post by: byte on May 31, 2008, 12:22:16 AM

Moving this topic to the SME 7.x contribs forum, it is more appropriate there. Thanks!

Title: Re: Phpmyadmin multiuser doesnt work ??
Post by: vincentmeek on May 31, 2008, 01:39:02 AM

Login as Admin goto privileges add user and password have database created to match username or grant privileges to the desired database.  Logout and back in as the newuser.

http://www.phpmyadmin.net/documentation/#faqmultiuser
section
 4.5 Is it possible to let users create their own databases?

Starting with 2.2.5, in the user management page, you can enter a wildcard database name for a user (for example "joe%"), and put the privileges you want. For example, adding SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER would let a user create/manage his/her database(s).

Title: Re: Phpmyadmin multiuser doesnt work ??
Post by: william_syd on May 31, 2008, 02:27:16 AM

Quote from: futureng on May 30, 2008, 08:11:39 PM

i dont understand. help me pls.

MySQL users are not the same as System users.

Title: Re: Phpmyadmin multiuser doesnt work ??
Post by: futureng on May 31, 2008, 12:06:08 PM

i am creating new user but not login. example:
(http://85.99.120.55/gimptribay/sme1.jpg)
(http://85.99.120.55/gimptribay/sme2.jpg)

Title: Re: Phpmyadmin multiuser doesnt work ??
Post by: futureng on June 05, 2008, 09:49:01 AM

My problem is not resolved.

Title: Re: Phpmyadmin multiuser doesnt work ??
Post by: Stefano on June 05, 2008, 10:59:52 AM

Quote from: futureng on June 05, 2008, 09:49:01 AM

My problem is not resolved.

you are trying to login on sme using mysql credentials.

Please read CAREFULLY the documentation

Ciao
Stefano

Title: Re: Phpmyadmin multiuser doesnt work ??
Post by: futureng on June 05, 2008, 01:53:42 PM

i do with console step by step on "http://wiki.contribs.org/Phpmyadminmulti"
but it doesn't work. idont understand.

is there Any other documents.?

Title: Re: Phpmyadmin multiuser doesnt work ??
Post by: vincentmeek on June 06, 2008, 01:52:36 AM

open  web browser and goto https://your sme server/myadmin/

replacing "your sme server" full name or ip address of your server.

login as admin
password admin

on the next screen click on

 "Privileges" in center column of screen.

 Scroll down until you see  "Add a new User"

 then follow the instructions above from "futureng"

 Browse around and become familiar with the interface.

 Create a database and assign privileges to that database to the user smeuserx you created earlier

click on the home icon in upper left corner

When on home page click on phpMyAdmin documentation in the right column.  Should find what you need here.

 click on the home icon in upper left corner
 
 Logoff  center of screen at bottom of list

 goto https://your sme server/myadmin/

 or just log back in as the user you just created.

   As mentioned earlier SME users and mysql users are not the same thing.