Deleted Root User From Mysql.user !!!
While trying to grant access to root user, i deleted all entries for root from mysql.user.
I've tried to use root% (anonimous built-in administrator user) but to no good).
Is there another admin user i could use to run mysql monitor and insert root records to mysql.user? I've read
Could I use a copy of the mysql.user table?
I'm using version 5.0.16-standard on Linux Fedora Core 3.
Before ruinin the root user, i made a backup of a databasefrom the same server (not mysql database); i was wondering if that backup contains the mysql.user information somehow?
View Complete Forum Thread with Replies
Related Forum Messages:
Deleted Root User From 'user' Database!
I so stupidly deleted the root user from my mysql > user database. Now I can't login to mysql. I uninstalled the rpm and reinstalled it but it still won't let me setup a new root user. How can I delete the mysql data files so that I start again, fresh? Where are these files located? I can't find them anywhere after removing the RPM but they are obviously there because upon reinstalling the RPM I'm still in the same position--I try to do mysqladmin -u root password 'password' but it says "Access denied for user root@localhost"
View Replies !
Deleted The Root User
i deleted it thorugh phpmyadmin. I wanted to look at its properties... and i pressed the wrong submit button and it was gone. Ive tried deleting all the stuff... delete /usr/lib/mysql and my.cf and reinstalling... but its still gone. phpyadmin says i dont have permissions to do anything. and webmin says it cant login with ' @localhost' with no password. I 1) stopped the service 2) yum removed mysql and mysql-server and dependancies 3) removed the database files listed above 4) reinstalled 5) blew up my house because it is still gone
View Replies !
Root User Denied Access To Fetch User List.
I can still log onto MySQL administrator or the command line program but I somehow appear to have lost all priveliges to alter or view the user list from this account. Even under the command line interface I can login but it tells me access is denied when I try to alter "root" permissions on a database. I cannot seem to log onto any of the other accounts created but obviously if I could get into the user admin I could solve this.
View Replies !
Mysql User Deleted
So I decided to make my personal windows machine into a apache/php/mysql server just to play around with and I encountered some problems while using phpmyadmin. First thing I did was login as root to phpmyadmin and then I created some users and databases. Started toying around with the user privileges, then logged in as another user with limited privileges, yet the user had the same privileges as my root account. Then I logged back in as root and deleted the user, and here's the part thats messed up. The user that I deleted still exists even after I deleted it. I was able to access the database with that user and do whatever changes I wanted to do. I even installed mysql administrator to see if I could delete that user from there, but the user doesn't even show up on there. Any ideas on what could be causing all these problems?
View Replies !
Deleted MySQL User!!
I deleted the phpbb mySQL user lastnight by mistake, is there any way I can add a new user and make it work again without hacing to reinstall?!
View Replies !
How Do You Log In As Root User On A Mac In Mysql?
Basically I want to login as the root user and I simply can't. I do this: mysql> -u root and nothing happens when i use the status command it shows that the user is: russjones@localhost I do not have any problems on windows, but I'd like to use the mac. Does this have anything to do with a bash profile?
View Replies !
Installing Mysql As User, NOT Root
I've had to install mysql as a regular user, and not as root. Before it was so simple since I was root but now I am on someone else's server. I downloaded a non-RPM Standard5.0.19 binary. I untarred it and blindy tried to start it and of course got a number of errors. I found that mysql 4.1.12 was already running. I took a look at http://lists.mysql.org/mysql/42514 and decided to make some changes: - uid - TCP port - socket file - basedir - datadir In mysql.server (in support-files) I changed the basedir and datadir to (/apps/myaccount is my home acct) /apps/myaccount/base and /apps/myaccount/data, but as the above listed post mentioned, I also need to change 3 other things. I need to put everything into my home account, so how should I change the uid, the tcp port, and the socket file?
View Replies !
User Problems... Only Root User "works".
i have been trying to figure this strange problem out for a week or so. here it is. i have a set of users with various permissions for different reasons. about 2 weeks ago, my hardware suffered a fairly nasty failure. i recovered everything. things seemed to work out. i didnt think to check my phpBB forums or my blog (or other mysql based stuff). never had any problems with the DB... so, maybe i am missing something simple here. i hope so. what my users can do: they can log in via command line, a gui i use on mac os x and it does not matter if it is local, or remote. they work just fine. what all but one users cannot do: none of my users can run phpbb or the blog stuff.. except for the root user. any other user returns the error message written in the code of which ever script i try to access telling me that "could not connect to DB" etc.. root works fine. now, i thought maybe it was a problem with the forums and other stuff. but i cant be. same thing happens with all things... even a game server i occasionally run that keeps account info in a DB. all these users are set up properly and have worked just fine in the past. nothing new has been installed, no conf changes..im at a loss...
View Replies !
Root User And Developing PHP/MySql WebSite
my webhosting company defaulted a root user with no password. I created a user for myself with a password, but wondering if having the root user without a password will leave the database open to intrusion. What's it there for, anyways? On another note, what is a good IDE for developing a PHP/MySQL website that will be served from a UNIX server, but developed on a windows PC?
View Replies !
Adding Mysql User - Only Root Is Able To Login From A Remote Client.
hey all. need some quick help with user admin in mysql. so currently, I have a linux box with port 3306 open or mysql administration using navicat. I'm able to connect to the mysql server through navicat if I'm using the "root" username. For some reason, whenever I atmysqlt to add a new user to mysql, i'm not able to connect to mysql through navicat or the mysql prompt. First, trying to add user for localhost: INSERT INTO user (Host,User,Password) VALUES('localhost','aaron',PASSWORD('abc123$')); Then grant privileges: GRANT ALL ON *.* TO aaron@localhost; Now when I try: $mysql -u aaron -p I enter in the password (abc123$) and it tells me access denied.. What am I missing?
View Replies !
Root User
I have properly installed via the latest version of Windows Essentials of MySQL, I ran the installer and left it make the job. I have given a password to the root account, but while installing PHPMyAdmin, the programm cannot access the root user.
View Replies !
How Do I Log In As A New User (not Root)?
I'm new to MySQL and I'm going through a book called PHP and MySQL Web Development (Luke Welling and Laura Thomson). I created a new user for the web according to the book with: mysql> grant select, insert, update, delete, index, alter, create, drop -> on books.* -> to bookorama identified by 'bookorama123'; It then says to log out of the MySQL monitor by typing 'quit', and then log back in as the web user to test that everything is working correctly. But every time I start the MySQL monitor the first thing it says is 'Enter password: '. I'm guessing that's just for the root user since that's the only password it will accept. How to I log in as the web user I created? I've searched all over but could not find anything on this....
View Replies !
User Root Locked Out.
I have mysql 4.0.16 database running on a windows machine, it was running fine. I didn't use it for a week and now when I try to go into it and delete some records it tells me access denied for root, I can't create users or modify anything. When I do a show grants it says all grants for user root.
View Replies !
Locked Out - Root User!
Code: mysql> UPDATE mysql.user SET Password=PASSWORD('foobar') WHERE User='root'; ERROR 1142 (42000): UPDATE command denied to user ''@'localhost' for table 'user' mysql> Code: # /usr/bin/mysqladmin -u root password 'foobar' /usr/bin/mysqladmin: Can't turn off logging; error: 'Access denied; you need the SUPER privilege for this operation' ran /usr/bin/mysql_secure_installation Code: Set root password? [Y/n] Y New password: Re-enter new password: ERROR 1142 (42000) at line 1: UPDATE command denied to user ''@'localhost' for table 'user' Password update failed! and some more info... Code: mysql> show grants; +--------------------------------------+ | Grants for @localhost | +--------------------------------------+ | GRANT USAGE ON *.* TO ''@'localhost' | +--------------------------------------+ 1 row in set (0.00 sec) mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | test | +--------------------+ 2 rows in set (0.01 sec)
View Replies !
Can't Use CREATE USER As Root?
I've just freshly installed mysql on my debian system. Binary from the repository, didn't have the nerve to do a source installation. I did mysql_install_db, set my root pw and logged in. Of course, I wanted to create a new user. But what do I get? Your MySQL connection id is 1 to server version: 4.0.23_Debian-7-log Type 'help;' or 'h' for help. Type 'c' to clear the buffer. mysql> CREATE USER bla; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'USER bla' at line 1
View Replies !
Cannot Connect As Root User
I'm new to MySQL and have just installed in on a WinXP Pro system but now I cannot login as the root user. When I key in mysql -u root I get ERROR 1045: Access denied for user 'root@localhost' (Using password: NO) Also I cannot connect the mysal database. When I type mysqlshow mysql I get mysqlshow: Access denied for user '@localhost' to database 'mysql' I can't seem to do anything in WinMySQLAdmin. Please help, I've surfed the web and have not been able to find the solution.
View Replies !
No Privileges For Root User
There is no privilege for root @ % for create user, create view, procedures etc. I tried to edit the user table directly. But it doesnt work. Please help to find a solution.
View Replies !
Change The Root User Password
I have just set a password for the root user for logging into MySQL which all works fine by typing: mysql -u root -p A prompt appears asking me for my password which I enter and the usual welcome message appears.I initally set my root user password by typing at command line: mysqladmin -u root password "new password" ("new password" being the password I chose) This all worked ok. However I would like to know how to I change the password for the root user, and how would I also change the password for users that I set up (I assume it would be a similar way)? I am currently running all on my local machine (hence no need to use "-h" anywhere in the login procedure) and running on windows 2000.
View Replies !
Can I Set Database User Password When No Root Pw Is Set
I have installed PHPBB MediaWiki and SugarCRM on Ubuntu Server LAMP. I initially tried to set the root password on install and then could not log back in. After reinstall this is what I did for a new non root user. root@invest:~# mysql -V mysql Ver 14.12 Distrib 5.0.38, for pc-linux-gnu (i486) using readline 5.2 grant CREATE,INSERT,DELETE,UPDATE,SELECT on pauldb.* to paul@localhost; set password for paul = password('mysecretpassword'); flush privileges; exit; Then when i go to login with this user I can't. I have not set a password for root because the same thing happened when I tried to set root pw immediately after install of the database. This time I am trying to work out the access issue with a new user i have created. This way I still have access since and I won't have to reinstall the db.
View Replies !
Can Not Change Password For Root-user
I can't seem to change the password for my root-user in MySQL. When I go into mysql and type; UPDATE mysql.user SET Password=PASSWORD('mypassword') WHERE User='root' AND Host='localhost'; I get the following error; ERROR 1044: Access denied for user: '@localhost' to database 'mysql' How can I change my root-password in the best way?
View Replies !
Unintentional Delete Of Root User
Iam Xampp and Windows XP User and I unintentionally deletet user "root" as I want to install Joomla 1.53. I want to create back new user root. but i don't how to create new user via localhost. Mod or other member could help? This error message i received I type http://localhalhost/novi.indexphp. : #1045 - Access denied for user 'root'@'localhost' (using password: NO) Edited 2 time(s). Last edit at 07/18/2008 06:25PM by bob ahmad.
View Replies !
Warning: One Can Only Use The -- User Switch If Running As Root
I started the mysql database with the "safe_mysqld" command and with the user who own mysql. in the errr-log file, I have that: 050123 23:16:50 mysqld started Warning: One can only use the --user switch if running as root /exlibris/sfx_ver/sfx_version_2/app/mysql/libexec/mysqld: ready for connections What is the meaning of "Warning: One can only use the --user switch if running as root" ?
View Replies !
Create User With Full Privileges As Root
I am trying to create a user with full privileges in addition to the root account, without that user being able to modifiy or even see root's databases. (My goal is to have a user that can create and edit databases, but without being able to access roots stuff). Does anyone know how to do this? And while on the topic of users, when doing a grant to username, is it possible to see if the username already exists and to stop the overwrite of that users priveleges?
View Replies !
LOAD DATA INFILE And User Root
I wonder does anyone know the answer to this issue: myAppDB is a schema under my version of MYSQL 5.1 which has a user called myAppUser. myAppUser has been granted all available privileges to myAppDB. I am also using Java servlets written in NetBeans to upload Excel spreadsheets into tables in myAppDB. However, when it comes to using LOAD DATA INFILE for bulk updates, myAppUser is denied access to myAppDB. Yet if I use profile root instead of myAppUser, the upload is successful.
View Replies !
Access Denied For User 'root@localhost'
I have installed MySQL and somehow have my forum running fine using it, however, I am attempting to install Photopost php software and I have put in the user name that I have been using. It all works fine up until it tries to create tables on the database (and maybe even a database, the error message isn't telling me much). I have tried to log into mySQL but keep getting the error: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) The error I get from the install page (of Photopost) is: Could not connect to or create the PhotoPost Classifieds database. Be sure your user has permissions to CREATE or create a blank table before hitting REFRESH or go back to Step 1 to check your database settings. Presumably I need to go in to mySQL as root and set CREATE etc... permissions for the user that I have specified in the Photopost install script? How can I do this? I have never set up a root password for mySQL. I am completely new to MySQL (although I have used it for my own developments on Windows, but never on Linux).
View Replies !
Using Non Root User To LOAD DATA INFILE
I am trying to set up a web app that will allow admin users to upload .csv files. those files are then processed and imported into the MySql db. I keep getting a 42000Access denied for user 'username' to database 'db' error. I have checked the user's permissions, and they have as much access as i can give them to the particular db.
View Replies !
Access Denied For User 'root'@'localhost'
I am having this error message: Check the pictures #1045 - Access denied for user 'root'@'localhost' (using password: YES) I am using WAMP5,I tried to change the password in config file but no use.last time I had to uninstall and reinstall to reset the root password. what am I doing wrong?am I looking at the wrong file?
View Replies !
Error: 'Access Denied For User 'root'@'localhost'
I've used mysql on an XP machine before, but only a little. I installed Fedora core 5 on this machine (i386) and have mysql 5.0 running. I understand that this is a common problem and I have been searching for a solution for a few days now. When I was configuring Fedora using this guide (FYI: I only installed what I needed), I used this command to set the root password (assuming that I was using 'root' as my password): mysqladmin -u root password root Then, I tried this command to login (as instructed by the guide I was following): mysqladmin -h localhost -u root password root This is where I got the error: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' Now, I have tried many methods to fix this. I tried every method to reset the root password as instructed by the mysql documentation. I also installed Fedora core 5 on another hard drive at home to see if I would still get the same error and I did. I know that localhost is the correct host name and the mysql service was running while I was trying to login. I've read a lot of post here already and nothing has helped me.
View Replies !
Access Denied For User 'root'@'localhost' (using Password: YES)
I am trying to login to mysql using 'mysql -u root -p' with password.but iam getting this error "Access denied for user 'root'@'localhost' (using password: YES)". i have googled for this error and i saw that if i enter a wrong password i get this error.but i am 100% sure that the password is right because i used it in a sample program where i gave that password to connect to mysql.
View Replies !
Error 1203 User Root Has More Than 'max_user_connections' Active
This error occurs when I atmysqlt to connect to a database via MySQL Administrator or phpMySQL. Everything was working yesterday, when I left work. And this morning, voila...cannot get in. I've just installed PHP, MySQL and phpMyAdmin on my test machine, Windows XP, running IIS 5.1. And was about to install everything on the development server, windows 2003, running IIS 6. And subsequently a production machine. I REALLY need some help here. The only thing that changed is that Microsoft updated my computer last night automically. Auto reboot.
View Replies !
Delete /Change Localhost For Root In User Table
I have updated my Host-Information for root in the users table - and guess what happened - I can't login with root anymore. What is more - I took as update address something like http://serverbla.com. So guess what, I can't login because of the protocol information. Since I have a webshop installed on the machine I would like to reset only this information. Is there any chance to do that without crashing the webshop?
View Replies !
#1045 - Access Denied For User 'root'@'localhost' (using Password: NO)
I have successfully installed the following IIS ver 6 php ver 4.4.9 MYSQL ver 5.0.67 when i tested through command line i get no error and i am view the php pages on the browser without any hitch. In the beginning when i was trying to connect to MYSQL through simple php script i was getting an authentication error which i could resolve by using OLD_PASSWORD. Now during final stages , Now when i have installed phpMyAdmin ver 2.0.8.3and have also configured config.inc.php. There is persistent error i am getting which is something like MYSQL says #1045 - Access denied for user 'root'@'localhost' (using password: NO)
View Replies !
Login As Root User, And Grant Create Database Privileges
I am new, and I have been trying to find info on this unsuccessfully. Ok, so I am using Unix Terminal from my Mac. From the command prompt, I use Shell>/usr/local/mysql/bin/mysql to log in to the localhost user. Now, from the command prompt, i have tried using ,mysql -u root, and it says command not found!
View Replies !
Error: 'Access Denied For User: 'root@localhost' (Using Password: NO)'
I've installed MySQL 4.0.26 on OSX 10.3.9 client version using the standard darwin 7.9.0 PKG. Installation seemed to go fine but I can only access Mysql with urs/local/mysql/bin/mysql test To my knowledge I never sent a root or user password. When I come to try and set a password or create a database I am asked for my password. When I try and enter it the imput is frozen and the only keystroke that will work is 'enter' then I get a error message that tells me that it is the incorrect password. I have tried all of the different login and password reset commands I can find but to no avail.
View Replies !
ERROR 1045 (28000): Access Denied For User 'root'@'localhost'
Using mySQL 4.1.22 on Linux, I got this error message suddenly this morning (it worked ok yesterday): --------- [root@server]# /usr/local/mysql/bin/mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) ---------- I created a '/root/root.sql' file: -------- SET PASSWORD FOR 'root'@'localhost' = PASSWORD('xxxxxx'); -------- And killed the process and restarted: -------- [root@server ~]# /usr/local/mysql/bin/mysqld_safe --init-file=/root/root.sql & [1] 2494 [root@server ~]# Starting mysqld daemon with databases from /usr/local/mysql/var -------- But I get the same error message :( In my '/usr/local/mysql/var/server.err' file there's no error message: -- 070220 07:03:40 mysqld started 070220 07:03:40 InnoDB: Started; log sequence number 0 3758734 /usr/local/mysql/libexec/mysqld: ready for connections. Version: '4.1.22' socket: '/tmp/mysql.sock' port: 3306 Source distribution ------- What am I doing wrong?
View Replies !
Error 1142 - Mes. The Following Occured: SELECT Command Denied To User Xx@hostx.com For Table 'user
When trying to do anything to do with "User Administration" in MySQL Administrator 5.1 connecting to a remote MySQL database, I get the following message when I click on the "User Administration" icon/text in top left frame. Verbatim quote apart from my connection details which I am anonymising): A MySQL error was encountered. The message is: Could not fetch user names. The following occured: SELECT command denied to user xxx@hostxxx.xxx.xxx.com for table 'user' (1142) No I have looked through search and found the following: http://lists.mysql.com/mysql/134369 Unfortunately that tells me that it has happened to someone else but that's about it. What is one supposed to do with the fix? I am wondering if this is why I cannot create ordrop any tables with this username at the moment, even though it is the Admin level username....
View Replies !
Copy User Privileges To A Newly Created User.
I have just created a user with specific permissions to certain tables in different databases. Now I have to create serveral more users with the same permission. Is there a command in MySQL that allows me to create the new user by copying the privileges from a template user?
View Replies !
|
TRACKER
