Can Any Body help my in installinh phpMyadmin on MyCobalt RaQ3 Server

The problem is that when I try to open phpMyAdmin I get the following:-

Parse error: parse error in /home/sites/site1/web/siteload/phpMyAdmin/config.inc.php on line 15

Warning: Variable passed to reset() is not an array or object in /home/sites/site1/web/siteload/phpMyAdmin/lib.inc.php on line 102

Warning: Variable passed to each() is not an array or object in /home/sites/site1/web/siteload/phpMyAdmin/lib.inc.php on line 103

Does Any One Know What could be possibly Wrong ?
Thanks In Advance

Originally posted by kunalsood



Parse error: parse error in /home/sites/site1/web/siteload/phpMyAdmin/config.inc.php on line 15


Check the 15th line at the config.inc.php file. It should be the password configration line- is there any syntex error there ? Maybee you deleted on mistake some ' or something... Can you pest this line here so i will be able to check ?

It Looks like this :-

$cfgServers[1]['stdpass'] = 'pass';

It's looks ok...
I don't know what is the problem there.

Check you whole config file (Did you configured all well) ?
Also, I noticed that the ext of your config file is PHP , on my machine it's PHP3, did it orginally was PHP3 and you changed it to PHP ?

You should also check whether you are using basic or standard authentication.

(question for RaQ users : Do RaQs have auth_PAM installed?) If so, then you should use basic authentication.

Only use advanced authentication once you are familiar with HTTP_AUTH.

Can you post line 14 please? The error is most likely on that line and not line 15. Check that the line ends with ;

It look like :-

$cfgServers[1]['stduser'] = 'root';

Make sure that the # comment placed in the config.inc.php file has not wrapped to the next line (which can happen if you're editing in an environment like joe or pico). That usually causes the parse problem.

If it has wrapped, then place a

#

in front of the 'description' and that should fix the parsing problem. Or, just delete the 'description' comment altogether (if you can remember which is advanced authentication and which is basic).

Thanks BC That Worked but can any one tell me how I can give access to 1 MySQL Database to each of my Clients Using phpMyAdmin ?
Thanks Everyone For Your Help.
That Was Great :)

You will need to spend a bit of time with the MySQL manual to make it work - http://www.mysql.com/documentation/mysql/commented/

Suffice to say you need to use mysqladmin through Telnet to create and manage new MySQL databases for your users and assign different privilege levels. It's quite complex so I suggest you set aside a few hours for a few days to go through it. You'll find it quite useful.

6 steps to do this.

Suppose your client's uid/password is tom/tompass, and
you are going to create a database named tom_db for him.

step1. login your server as admin or root
step2. > mysql -u ur_mysql_root_uid -p mysql [enter]
step3. mysql> grant all privileges on tom_db.* to tom@localhost identified by 'tompass' ; [enter]
step4. mysql> create database tom_db ; [enter]
step5. mysql> exit [enter]
step6. > exit [enter]

That's it.

===================
http://168host.com

[Edited by raylin on 01-04-2001 at 01:02 AM]

Originally posted by raylin
6 steps to do this.

Suppose your client's uid/password is tom/tompass, and
you are going to create a database named tom_db for him.

step1. login your server as admin or root
step2. > mysql -u ur_mysql_root_uid -p mysql [enter]
step3. mysql> grant all privileges on tom_db.* to tom@localhost identified by 'tompass' ; [enter]
step4. mysql> create database tom_db ; [enter]
step5. mysql> exit [enter]
step6. > exit [enter]

That's it.


Hey, that's just what I wanted to know. Thanks! ...So how do we go about deleting a database?:confused:

Suppose your client's uid/password is tom/tompass, and
you are going to delete tom's database.

step1. login your server as admin or root
step2. > mysql -u ur_mysql_root_uid -p mysql [enter]
step3. mysql> drop database tom_db; [enter]
step4. mysql> delete from db where user='tom'; [enter]
step5. mysql> delete from user where user='tom'; [enter]
step6. mysql> exit [enter]
step7. > exit [enter]

i have installed newest version of php my admin but i am getting this message

You haven't enabled magic_quotes_gpc in your PHP configuration. PhpMyAdmin needs this to work properly. Please have a look at the configuration section of the PHP manual for information on how to enable it.


Can somebody tell how to enable this?

Also ..... in the new version of PHPmyAdmin they say that now we can assign databases to clients through web interface of phpmyadmin, don't have to go to command prompt ... so should i still use the above given method?

Talk about resurrecting old threads! :D

To enable magic quotes, you must edit the php.ini file present on your system and switch it to on. Look for 'magic_quotes_gpc'.

Be wary that some scripts/programs require magic_quotes to be switched off for whatever reason.

You can assign databases to clients if the user you are running has the appropriate privileges granted to control other users (i.e. a user with root access level or approximate).

I enabled magic_quote_gpc at etc/admserv/php.ini and /etc/httpd/php.ini but the message is still same ...

What should i do now ?

Have you rebooted HTTPD (the Apache daemon) for the new changes to take place?

NOPS .... how to do? :(

/etc/rc.d/init.d/httpd restart

Thanks :D its working now ...

I LOVE WHT ! ;)