Jump to content
The Uniform Server Community

nalfeshnee

Member
  • Posts

    2
  • Joined

  • Last visited

nalfeshnee's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. Hi Olajide! Thanks for the really fast reply, still no luck though. Did exactly as you suggested: A. Download a NEW copy of 3.4-Sluger CHECK B. Start the server using Server_Start.bat CHECK C. Go to the Admin Panel http://localhost/apanel CHECK D. Click Run MySQL CHECK E. Go to phpMyAdmin CHECK F. Create Database CHECK G. Drop Database FAILED I then checked out the other thread and saw that, as said there, the DROP privilege was not set. OK, so I go to "Privileges" and click on the root account and check the "DROP" box. I then click "Go" and get: Error SQL query: GRANT ALL PRIVILEGES ON * . * TO 'root'@'localhost' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0; MySQL said: #1045 - Access denied for user 'root'@'localhost' (using password: YES) Note that Metaltailz suggestion Thus did not work. I'll have a go at installing this at home -- maybe it's the office system that's shot. Cheers, Ed
  2. Hi Folks, I have a general MySQL problem. It's not just PHPMyAdmin -- it seems to be more the way MySQL is setup (?) Here is what I can confirm is working: * I can add users * I can add databases * I can import SQL Here is what I can confirm is not working: * I cannot add user rights to databases (i.e. cannot modify a user to give him rights to a DB) * I cannot drop databases I started with the root password as standard and when that didn't work, I changed it. Still didn't work. I have followed all the instructions here: http://brionews.com/alt/sql-error-1045-workaround.txt. Still no luck. I have tried with the MySQL official SQL tools -- specifically, MySQL Query Browser -- and it doesn't work there, either. For example: CREATE DATABASE 'mydb'; // database is created DROP DATABASE 'mydb'; // database cannot be dropped, error given as: "Access denied for user 'root'@'localhost' to database 'mydb' That's too weird. I guess I could now go ahead and install a fresh copy of MySQL, but having spent an hour on this I'm going back to Uniform Server 3.3 for now :=) Cheers, Ed
×
×
  • Create New...