Please support our PHP advertiser: Lunarpages PHP Web Hosting
Views: 4245 | Replies: 15
 |
•
•
Join Date: Apr 2005
Posts: 15
Reputation: 
Rep Power: 4
Solved Threads: 0
Newbie Poster
on the index.php page under create new database listed is no Priviligies. How can i correct this.
it seem to be working fine but then i think i played around with priviligies to get mamboserver working. after that all my databases were gone and i can't seem to add new databases as NO PRIVILIGIES is stopping me doing it.
Thanks in advance.
it seem to be working fine but then i think i played around with priviligies to get mamboserver working. after that all my databases were gone and i can't seem to add new databases as NO PRIVILIGIES is stopping me doing it.
Thanks in advance.
•
•
Join Date: Jul 2005
Posts: 12
Reputation:
Rep Power: 4
Solved Threads: 0
Newbie Poster
I have the same issue on my server -- no database priviliges. This is controlled by your system administrator, talk to them.
I recently did an install of Mambo, as well. Although the installation instructs you to create a database titled "mambo," this is not necessary. Whatever database you have access to will work -- the installation will add a "mos_" prefix to all of the table names to make them unique to Mambo.
The installation is relatively easy and shouldn't take longer than 20 minutes.
I recently did an install of Mambo, as well. Although the installation instructs you to create a database titled "mambo," this is not necessary. Whatever database you have access to will work -- the installation will add a "mos_" prefix to all of the table names to make them unique to Mambo.
The installation is relatively easy and shouldn't take longer than 20 minutes.
•
•
Join Date: Apr 2005
Posts: 15
Reputation:
Rep Power: 4
Solved Threads: 0
Newbie Poster
issue is how do i restore priviligies. does anyone know about mysql command for it.
i agree with you that installation is very easy.
i agree with you that installation is very easy.
•
•
Join Date: Apr 2005
Posts: 15
Reputation:
Rep Power: 4
Solved Threads: 0
Newbie Poster
also i took out old phpmyadmin and reinstalled new version 2.6.3-pl1 . but still NO PRIVILIGIES is displayed. how can i make this work back to normal as before when i played around with it.
•
•
Join Date: Jul 2005
Posts: 12
Reputation:
Rep Power: 4
Solved Threads: 0
Newbie Poster
I'm not much of a database sort of person. If it were me in that situation, I would probably reinstall the MySQL server -- it sounds like this is an issue with the server, and not phpMyAdmin. Sorry I can't be of more help.
•
•
Join Date: Jun 2005
Location: Kansas City, Missouri, USA
Posts: 345
Reputation:
Rep Power: 4
Solved Threads: 4
Posting Whiz
Let me preface this by saying, I'm not a MySQL DBA. I do have a lot of experience, though.
In your phpMyAdmin conf file (config.inc.php), have you specified "root" as the user? Your "root" user should have all privs. Did you modify the root user's privs? I'm not even sure you can limit the "root" user. If so, you could paint yourself into a corner--only solution would be to re-install MySQL.
Are you working on Windows or Linux? If on Windows, open the MySQL Command Line Client and enter your root password. If on Linux, use the mysql command to connect as root to your mysql database. In the example below, replace mypass with your root password. "mysql" at the end of the line is the database name---mysql is the system database which is what you want to connect to for managing mysql users.
Once connected as root, you can query the system tables to get information about users. If you are on Linux, adjust the output file below to something like /var/log/mysql_out.txt. Try this series of commands hitting ENTER after each:
Now open the text file in your favorite text editor and peruse the results. You should see what users exist and what privs each has. If you need to fix something, check out the GRANT and REVOKE commands. See MySQL documentation. http://dev.mysql.com/doc/mysql/en/grant.html
More command line help:
http://dev.mysql.com/doc/mysql/en/mysql-commands.html
http://dev.mysql.com/doc/mysql/en/mysql.html
http://www.washington.edu/computing/...ql-client.html
In your phpMyAdmin conf file (config.inc.php), have you specified "root" as the user? Your "root" user should have all privs. Did you modify the root user's privs? I'm not even sure you can limit the "root" user. If so, you could paint yourself into a corner--only solution would be to re-install MySQL.
Are you working on Windows or Linux? If on Windows, open the MySQL Command Line Client and enter your root password. If on Linux, use the mysql command to connect as root to your mysql database. In the example below, replace mypass with your root password. "mysql" at the end of the line is the database name---mysql is the system database which is what you want to connect to for managing mysql users.
mysql --user=root --password=mypass mysql
Once connected as root, you can query the system tables to get information about users. If you are on Linux, adjust the output file below to something like /var/log/mysql_out.txt. Try this series of commands hitting ENTER after each:
tee c:\temp\mysql_log.txt show databases; use mysql; show tables; select * from user; select * from db; select * from tables_priv;
Now open the text file in your favorite text editor and peruse the results. You should see what users exist and what privs each has. If you need to fix something, check out the GRANT and REVOKE commands. See MySQL documentation. http://dev.mysql.com/doc/mysql/en/grant.html
More command line help:
http://dev.mysql.com/doc/mysql/en/mysql-commands.html
http://dev.mysql.com/doc/mysql/en/mysql.html
http://www.washington.edu/computing/...ql-client.html
•
•
Join Date: Apr 2005
Posts: 15
Reputation:
Rep Power: 4
Solved Threads: 0
Newbie Poster
in response to Troy.
I am using mysql 4.0.24 on windows 2000 pro. ansd in my config.ic file i've specified root as the user. i think i might have played around with phpmyadmin when this happened, ex i added new user for test but then deleted it. then it went like as it is.
effectively i have limited myself of using phpmyadmin. i had other stuff on my apache folder that can now not be run. cause it also deleted all databases except test that i think comes as default.
and finally i did try re-installing with new phpmyadmin version 2.6.3-pl1. and i have tried your code. All in all still same problem faced.
look i appreciated your feedback but would appreciate you have any new ideas. thanks once again.
I am using mysql 4.0.24 on windows 2000 pro. ansd in my config.ic file i've specified root as the user. i think i might have played around with phpmyadmin when this happened, ex i added new user for test but then deleted it. then it went like as it is.
effectively i have limited myself of using phpmyadmin. i had other stuff on my apache folder that can now not be run. cause it also deleted all databases except test that i think comes as default.
and finally i did try re-installing with new phpmyadmin version 2.6.3-pl1. and i have tried your code. All in all still same problem faced.
look i appreciated your feedback but would appreciate you have any new ideas. thanks once again.
•
•
Join Date: Jun 2005
Location: Kansas City, Missouri, USA
Posts: 345
Reputation:
Rep Power: 4
Solved Threads: 4
Posting Whiz
Whoa! You say entire databases were dropped? Then you definitely have much bigger issues than simply a user acct with messed up privileges. So databases are missing, and root does not seem to have root privs---at least not when in phpMyAdmin.
Do you have any data left that you need to keep? I mean, did you lose all your valuable tables? If so, uninstall MySQL completely, and re-install. Also, delete your current phpMyAdmin files and start over with a fresh download of latest stable release. Sounds like you need to start over. If you have data you need to keep, export it into csv files so you can import it after a total re-install.
Do you have any data left that you need to keep? I mean, did you lose all your valuable tables? If so, uninstall MySQL completely, and re-install. Also, delete your current phpMyAdmin files and start over with a fresh download of latest stable release. Sounds like you need to start over. If you have data you need to keep, export it into csv files so you can import it after a total re-install.
•
•
Join Date: Apr 2005
Posts: 15
Reputation:
Rep Power: 4
Solved Threads: 0
Newbie Poster
Thanks.
I will try out your valuable advice. I will delete phpmyadmin, then uninstall mysql. i suppose deleting mysql would be to delete mysql folder and also look at add/remove in control panel right. and then re-install both. And yes all tables/databases gone. but nothing to worry about for me cause all apps were used like mambo, oscommerce, phpnuke, etc were used for test purposes.
will keep you updated on the progress. cheers.
I will try out your valuable advice. I will delete phpmyadmin, then uninstall mysql. i suppose deleting mysql would be to delete mysql folder and also look at add/remove in control panel right. and then re-install both. And yes all tables/databases gone. but nothing to worry about for me cause all apps were used like mambo, oscommerce, phpnuke, etc were used for test purposes.
will keep you updated on the progress. cheers.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
