Return Back All The Privleadges To The Root User
I accidently remove all the privleadges of the root user of MySQL on a web hosting server.I need your help that how i can return back all the privleadges to the root user.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
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.
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"
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?
No User Root ?
I did install psa software for some testing .. (webhosting software) Thogh I did un-install it and ebverything seemed fine for a few weeks, now this !.. >> mysqladmin: unable to change password; error: 'Can't find any matching row in the user table' . I have followed the instuctions to change password for root user from the mysql documentation.
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 programme cannot access the root user.
Root User
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?
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...
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.
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.
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?
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
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
Replace Root User
mysql ships with the default root user. I was wondering (for security) if it was possible to replace the root user with another user account or if the root user had certain privaliges that others could not have.
Connection Refused For Root User
I have installed mysql and thought I knew what I was doing from the last install. I switched OS from win98 to winXP. All seems ok. Green light is showing. connect fine from command prompt with just mysql command. But when I try to connect from a perl script the user and password is denied. Access denied for user: 'yrkylady@localhost' (Using password: YES) I know the password is correct because I'm getting it from the Admin panel #This File was made using the WinMySQLAdmin 1.4 Tool #3/2/2004 6:21:11 PM #Uncomment or Add only the keys that you know how works. #Read the MySQL Manual for instructions [mysqld] basedir=C:/mysql #bind-address=127.0.0.1 datadir=C:/mysql/data #language=C:/mysql/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M [WinMySQLadmin] Server=C:/mysql/bin/mysqld-nt.exe user=yrkylady password=sdasldkf
Remote Administrator For Root User
I have got linux server and I want to use Mysql Administrator with root user but it can't accept root user for remote connections how can I fix that or is there any way to do that?
Restore Rights Of User Root
I have the problem that I can't see all databases as user root and I have no longer the right to create new databases. How can I get this right (privilege) back?
Deleted Hostname From Root User
I did something really dumb I deleted the hostname from my main root user and now can't even use the mysql command in console any way i can fix this ???
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.
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?
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?
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.
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.
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?
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" ?
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).
Starting Mysql As Root User On Linux
I have created a user called mysql to administer the mysql installation. I can run mysqld_safe as the mysql user without any problems, however, when I try to run it as the root user with --user=mysql the process does not start and the following error message appears in the error log. 040706 17:03:06 mysqld started Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists! 040706 17:03:06 Aborting The user does exist, does anyone have any ideas what I am doing wrong?
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.
Access Denied For User 'root'@'host' To Database 'db'
i'm trying to connect from a remote host to a db, and I just cannot. I can make a successful connection to another db (test), but not to the productive db. I have tried some things (flush privileges, grant everything), but I still cannot connect to the db.
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.
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.
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: Ɗ.1.22' socket: '/tmp/mysql.sock' port: 3306 Source distribution -------
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?
ERROR 1045 (28000): Access Denied For User 'root'@'localhost'
I'm attempting to install Bugzilla. I'm stuck because the last two modules that are required in Perl won't run. The apparent reason is that the root login fails. I tried it manually to, and here's what I get: [root@10 bugzilla-2.18.3]# mysql -u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) I created the database and login via a Perl module called template: /opt/ActivePerl-5.8/bin/perl-static -MCPAN -e 'install "Template"'
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?
Access Denied For User 'root'@'localhost' (was "help!!! Just A Beginner..")
Hello i recently installed WAMP5 to handle my phpmysqlapache localhost sever. but when i go to the control panel and clicked the localhost and phpmyadmin everything seems fine because i can see the phpinfo window and also the phpmyadmin.. but not when i clicked the SQLite Manager.Unable to connect to database manager. Could not connect: Access denied for user 'root'@'localhost' (using password: YES).
ERROR 1045: Access Denied For User: '"root"@localhost' (Using Password: YES)
I have been working on this for three days (about 16 hours) to no avail. I have root access on a dedicated server running whm/cpanel on Redhat 9. I have followed every instruction from mysql.com as well as every suggestion I've been able to find. These are the two errors I bounce between: ERROR 1045: Access denied for user: '"root"@localhost' (Using password: YES) and ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) I'm out of ideas.
Back Up
I am using a linux hosting and hosting 5 websites on it. the main prob solutions i need is that i need to change my web server but don't know how to take backup of database and all that. So can any bosy tell me how to take a database backup so that i can make my files used on other server and how to use the backup on the new server.
Back Up
I am running php, mysql on window xp. when user insert something to the database (mysql). where does the information stored? I want to be able to make a back up copy of my data just incase I want to move from one pc to another...
Getting MySQL Back
I am getting relay-bin logs on my master server. They are all empty except for one line that reads: þbin I have no slave settings in my my.cnf file. Any idea where these are coming from and how to turn them off?
Schedule A Back Up
I am attempting to schedule an automatic back up through the MySQL Administrator (version 1.2.2) and I cannot get it to run. I can save the project, set my conditions, but it never actually runs. If I choose to run the back up now, it works. I have tried setting this up both remote and on the actual server. I do not receive any error messages, and do not know where to check to see if it even attempts to start.
Looking Back Query
I have two tables, WIDGETS and VERSIONS. The WIDGETS table has descriptive information about the widgets while the VERSIONS table contains IDs relating to different iterations of those widgets over the years. The idea is that from any widget in the database you can look forward and backward to see different versions of the widget through the years. Here are the tables: CODEWIDGETS widget_id name description year VERSIONS v_id new_id old_id
Back Up Database
I have MySQL 5.0.22 installed on Windows XP (32 bit) - on few machines. 1. To make a backup - do I have to run mysqldump or can I just copy C:Program FilesMySQLMySQL Server 5.0data somewhere? If so, how can I restore the database having data folder? 2. If I need to transfer the database from one machine to another (the same OS and MySQL) - can I use binary files from data folder or mysqldump is the only option?
How To Get ID Back After I Insert A New Row?
I have 2 tables , article and tags. article has 3 fields, id, title , content tags has 3, tagid, tagname, aritcle_id insert into article (title, content) values ('abc','abcd'); I need article ID back to insert tags into tags table. my solution is add new select statement before insert into article (title, content) values ('abc','abcd'); I can select max(id) from article, then use this id number to insert article and tags tables. not sure if this is only way to do it or there is a better solution. also, if there are alot users use my web application simultaneously, i am worry that user A issue select statment to get max ID, before he uses it. User B also select max id, then they probably get same ID number.
Using MySQL As A Back End
I have a couple MS access aplications that I have developed to be used by clients in managing their data. I have split these applications into a front end (containing only forms, reports and a scratch table) and a back end (containing the data in various tables). Currently both front ends and back ends are in MS Access, but I am looking too use a bigger back end. I have previously looked at MySQL vs. MS SQL server for a more robust back end, but I didn't have to make the switch at that time. Now I'm pretty sure I do. Is MySQL a good platform to use for this? or would I be better off with a MS SQL server?
What Back-end Database
I'm starting to learn Visual Basic. My aim is to develop a small downloadable application that can store and display contacts. It has to be small (say 2 mb footprint?). Q - First, will Visual Basic give me this small footprint ? Q - What back-end database is advisable (I'm familiar with MySQL), considering that the tables will be small ? Basic goal is that the application should be universally downloadable, installable (on all windows) and must fit in a small footprint. Q - Or let me ask very broadly - what technologies would *you* use if you had to develop such an application ?
|
TRACKER
