473,325 Members | 2,860 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

Admin Error

OK, I mucked up...

My ROOT user has NO priviliges on ANY table... I, however only have
INSERT and SELECT priviliges on the MYSQL table and SELECT on other
tables... Can I create a new user that can then fix ROOT?

Carl

Dec 15 '05 #1
3 1067
Read this:

http://dev.mysql.com/doc/refman/5.0/...rmissions.html

I couldn't explain it any better ;-).

Markus
Dec 15 '05 #2
Hmmm, that page talks about resetting PASSWORDS not permissions.. I
KNOW the password, it's just that user ROOT has NO permissions.

Thanks

Dec 15 '05 #3
In that case, do it with

grant all on *.* to root@localhost with grant option;

This gives user root all privileges on all databases.

Maybe you have to replace localhost with more specific entries, if they are
defined so.

Markus
Dec 15 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Perttu Pulkkinen | last post by:
I have this problem: If administrator closes administration window from "right-corner-X", how to reset administration session? Now it happens that after that kind of "illegal" closing operation...
1
by: Stephan Neuhaus | last post by:
Hi all. I'm having a problem that's driving me nuts. I am not familiar with Access, but I have read the FAQ, searched google, read the Access Security FAQ, and looked at the Access Web, to no...
9
by: Andy Sutorius | last post by:
Hi group, I am getting the "could not load type" error and I'm not sure how to debug. Obviously it's a namespace error but I don't see it. Below are code snippets. Yes, the files sit in a...
0
by: Együd Csaba | last post by:
> -----Original Message----- > From: pgsql-admin-owner@postgresql.org > On Behalf Of Együd Csaba > Sent: 2004. július 16. 12:23 > To: pgsql-admin (E-mail) > Subject: URGENT - Postgres won't...
0
by: micky | last post by:
Error message and webconfig file are like this.. it says "The entry 'admin' has already been added." but i didn't add admin user . what's problem?? ++++++++++++++++++++++++++++++++++++++++++++==...
0
by: Hughe Jass | last post by:
I currently have a user that's using DB2 without Admin rights to his local computer (XP SP2) and he gets an error message while trying to connect to a server. When I give him admin rights, he...
7
by: n00b | last post by:
I have a database in which Access is automatically generating a sequence of Admin tables. It is due to the ODBC error (which I haven't found yet) listed in the table. Access seems to generate...
5
by: Rahul Babbar | last post by:
Hi, I am getting the error while trying to take a backup of the schema according to the backupschema.sql written at http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0602... ...
2
by: Angahran | last post by:
I'm hoping someone can help me. I was trying to backup our eqdkp database and managed to remove all the admin access from the admin account :( I cannot use phpmyadmin or mysql to directly access...
2
by: Scott | last post by:
Attempting to install WCF service on stand alone 2003 server as a admin user (not administrator but user "WCF" i.e user added to local admin group). It fails with user error: The description...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.