Root@
in my users I've got a root@localhost and a
root@%. Is this redundant, or is there a reason for this? The original MySQL
install was done by an application we're running, but we've since added
additional databases.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Any One Can Log In As Root !!!
i am trying to set up mysql remotely for a friend who doesnt know how to use it. I am trying to set up access permissions for everyone. SELECT user,password,host FROM User; returns 3 users now, User Password Host root pw here localhost optimism_ pw here % phpbb pw here 127.0.0.1 as i am using dialup, i must have % cos i have a dynamic ip. however, the problem is that i can log in as root user without supplying a password. This obviously is a big problem, but i dont see why when all accounts have passwords, and root is set up only to allow from localhost.
Log In As Root
I'm running MySQL 4.1, php4 and iis5 on XP.For some reason, I have to have things set up to use the root account with no password. I have installed the mysqladministrator program that is a GUI, and have added other users and passwords, and in phpmyadmin added the same people, but the only thing that works with things like wordpress or anything else I'm using to set up connections only use the root account.
Root Password
So the root password was set to something that is currently unknown, how can I go about resetting it? I can see in the mysql database, ie the following path C:/program files/mysql/data/mysql in the file user.MYD that the user root appears to have password root but it does not seem to work. Any ideas? I don't have the disk to reinstall at the moment. Running version 4.0.21-nt
Finding What Your Root Is.
How do I find out what my root is? I don't mean my root password, I just mean my root in general. Like the root name.
Mysql -u Root?
If I type mysql -u root mysql, I have the message: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) If I type mysql -u root -p mysql, MySQL prompts me for the password. Is that normal? Shouldn't I provide my password in the command line?
Root Priveleges
for this particuler case, the root user does not have priveleges to update, insert, select database and so on. It fail also to grant user access control and create or drop database. I think I had changed the root priveleges wrongly. How to change back the root priveleges control in order to access all the functionality? Any superuser available in mysql other than root?
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 Permissions
root permissions are messed up, i'm unable to create new databases with root account and i cant change permissions for the root account while logged in as root mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'; ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Root Priveleges
for this particuler case, the root user does not have priveleges to update, insert, select database and so on. It fail also to grant user access control and create or drop database. I think I had changed the root priveleges wrongly. How to change back the root priveleges control in order to access all the functionality? Any superuser available in mysql other than root?
Root Removed
I want to use PHP and MySql under Suse Linux for my homepage. I removed the root user at the phpMyAdmin Side and I don't know how to recreate them. I can't give me the rights because there is no user who is allowed to do that. And my question. Is it possible to edit the rights without using any command.
Reset Root PW
I am using Fedora 7 with mySQL 5. something... I accidentally messed up the root password when setting mySQL up and need help... I set the password to... well... i don't know what its set to... I have followed the following steps but have a few errors... I will put them at the end: 1. Log on to your system as either the Unix root user or as the same user that the mysqld server runs as. 2. Locate the .pid file that contains the server's process ID. The exact location and name of this file depend on your distribution, hostname, and configuration. Common locations are /var/lib/mysql/, /var/run/mysqld/, and /usr/local/mysql/data/. Generally, the filename has the extension of .pid and begins with either mysqld or your system's hostname. You can stop the MySQL server by sending a normal kill (not kill -9) to the mysqld process, using the pathname of the .pid file in the following command: Code:
Old 'root' Password
I'm trying to install MySQL server 5.1 on Windows and I'm getting error # 2003. It seems that I have a previous installation (which I must have forgotten) which I uninstalled but the old root password is still in the data dir which was not removed in the uninstall and I require it to create a new one. How do I - a) remove the old one or b) discover the old password so I can reuse it ??
Unable To Log In As Root
I have just installed MySQL, PHP and Apache. I have been able to check that PHP and Apache are working together. I'm running on Windows XP. If I open MySQL through the start menu I enter the password and can use MySQL commands, use, insert, select etc normally and they work. If I try and log into MySQL using- mysql -u root password I get error ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) This also means that I cann't use mysql_connect() in PHP I am baffled why I can use MYSQL through the start menu but not the command line or PHP comand. Can anyone explain / fix this?
No Root Account
I just installed MySQL 5 on my Mac and the only connection I can make to the server is using a blank username and password. The problem with that is that I cant actually do anything as that account has no permissions. This surely cant be normal.
Problems With Root
So, I'm using: Windwos 98 SE MySQL 3.23.54 Apache 1.3.27 (if it metters) Php, the newest version on php.net My only purpose is to test my own php/mysql related sites. I will later upload them to a 'good' server. So, installing php and Apache went fine. But MySQL caused some problems: When I start winmysqladmin, (with server mysql-opt), and then start the mysql monitor (mysql), everything is fine. But when I set a password for 'root', or I create a new user, I am getting Error 1045: access denied for user root@localhost (or ODBC@localhost). I cannot access the database via phpMyAdmin even if no password is set.. (access denies for root@localhost) When I look at the user table, I see there are 2 users names 'root' is this normal?
SOS! Root Filled
I'd be GREATLY APRECIATED if someone could bail me out of this one! I logged into my server an hour ago just to find that the root partition is 100% filled: /dev/mapper/VolGroup00-LogVol00 34285296 32544556 0 100% / Because of that (I think), the data directory associated with my MySQL installation got shot (read: disappeared!). What would be the best way to recover the mysql data? The MySQL daemon isn't running, and I can't find anything under lost+found, either! Please help for I *really* need to get [some or most of] the data back.
Root Login Only
I have tried to create additional users with GRANT and INSERT INTO (FLUSH PRIVILEGES) but every time I start the mysql client only with the root password can I successfully login. How do I get it so I have to enter a specific user name then be prompted for password?
Password Except Root
I know that there is default user and password in MySql as root and admin, but i want to create my own user and password like xxxx as a user name and yyy as a password so please tell me the procedure to create the user.
Root Shutdown
i have installed both PHP and mysql BUT when i come to the part where i shall setup ""PHPRC"" as system variable and ""C:PHP"" as value. ISS stop's working. after tryingto find a solution here http://forums.devshed.com/iis-97/iss-problem-397461.html i was looking trou the event manager and found this just as i was trying to go to localhost. Application popup: PHP Error : Error parsing C:PHPphp.ini on line 681 For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. and on line 681 there is "Program FilesMySQLMySQL Server 5.0inmysqladmin" -p -u root shutdown
MySQL Root
I installed MySQL in RedHat 9's usr/local. I found the the 'data' folder with two subfolders:'mysql' and 'test'. Both subfolders are empty. I have 8 databases in total. There's no subfolders of each database! Where are they? As for the age group calculation, I'm still working on it. I've decided to use temporary table
Connect Via Root
I have just installed mysql 5 and accidentally set it to not allow root logon from remote machines. Whats the easiest way of fixing this? I need to logon via my own machine
Login As Root
Im using a WAMP setup of winXP pro, apache 1.3.31, mySql 4.1.21community-nt, PHP 5.1.6 and phpMyadmin 2.9.0.2 during the install of mysql i set a root password and after setup i created a new user using a 'grant all' statement in the client console. what i want to do is completely remove the root account and use the new superuser account i created. But - i cannot login with the new account; only as root with the root password Any suggestions how i can stop mySql from forcing me to use the root account.
Root Password
I installed mysql correctly I am assuming navigated to mysqlin and ran mysqladmin C:Program FilesMySQLin>mysqladmin -u root -p password Enter password: *********** mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' C:Program FilesMySQLin>mysqladmin -u root -p password Enter password: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' I am unable to log on as root and change the password. It says leave the password blank by default. I still will not let me connect. Do I have to start mysql.exe and type the mysql admin -u root from there
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?
Root Access
I got a somewhat wierd issue I was working on my databases when all of a sudden I get disconnected from the server. When I try to reconnect it tells me that root@MyIP is denied. I tried rebooting MySQL with --skip-grant-tables and then reissue the grant command for root which seemed to have worked, then I rebooted mySql again with the grant command turned on and I no longer have access to my sql server.
Root Password
i am new to mysql.i have installed mysql software which is provided with Linux CD .i need to provide password to root.i updated the user table to give password to the root.after restarting the mysqld service , i couldnt enter into mysql .one error message is displaying ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Root Account
i'm new at mysql and i acidently deleted the root account. now there are no accounts on it. is there any way to get the account back?
Root Password
All day i'm trying to reset the root password, our webserver was crashed this week, our controll panel software created a random password. I tried both methods for resetting the password, with the init tekst file and with the command -u root --skip-grant-tables. Everytime I get the same error within the command promt "Program too big to fit in memory" I tried this on two windows xp machines and one one windows 2003 server.
My Root Password
I have given root a password in MySQL, but now phpMyAdmin says "access denied". I've put the following line in config.sample.inc.php: $cfg['Servers'][$i]['password'] = 'password_goes_here'; but it doesn't seem to make any difference. How do I get phpMyAdmin to recognise my root password?
Root Password
How can I change root password for the mysql. Please provide me the exact steps.
Root@localhost
i've just installed Mysql5 on my notebook with windowsXP, and when i'm in 'server instance conf wizard', in the step 'apply security settings',it gives to me this error: error#1045 acces denied for user 'root'@'localhost'(using password:YES) i've already allowed the tcp port 3306, so i can't understand where the problem could be.
Changed Root Password, Now I Can't Do Anything
I am following the MySQL by Michael Kofler and looking at securing root access as currently it has no password. I've logged into the MySQL consol and changed password using : mysqladmin -u root -h localhost password XXX However, i now can't do anything in in mysql terminal it comes back "access denied for user 'root'@'localhost' (using password :NO)
Recovering Root Password
I am having MySQL 4.1 in Windows 2003 Server and I had forgotten my root password and I can not remember it.
Resetting Root Password
I have set up mysql 5.0 (or whatever the latest version is), but for some reason it has lost what i set my root password is and i am tearing my hair out tryin to get back into the database. I have attempted the commands it tells you to do on the mysql official documentation and it jus comes back with an invalid command and I have also attempted to skip grant tables, which allows me to change the password but as soon as i start the service running again it jus goes back to way it was and doesn't let me in :(. And also reinstalled it like a billion times to discover it keeps the old root setup.
Resetting The Root Password
Having a browse through Paul Dubois's book, MySQL (ISBN 0-7357-1212-3), I came across a section in which he describes how to reset the root password: 1. Shutdown the server by issuing a KILL under Unix or stopping the system service under Windows. 2. Restart the server with the --skip-grant-tables option which allows you to connect with no password and all privileges. 3. Reset the root password. Given that the person first has to have operating system root or administrator access to shutdown the server, wouldn't this qualify as a security hole in cases where the OS root doesn't own the database, for example, on shared machines.
Tgb1.1 Files In Root
Everytime MySQL starts it creates a pair of zero byte files in the root containing the base directory. The file name changes each time. At present its t1jk and t1jk.1 Does anybody know what they are for? and is there anyway to specify where they are created? i.e. on another drive or in another directory?
Root And Password Info
where MySQL saves the root and its password info? .. I need to automatically retrieve it from my app.. is it possible?
Mysqld_safe Runs As Root
I've installed MySQL 5.0.18 on Fedora Core 3 and I'm using mysql.server to start the MySQL database when the system is started. I've edited my.cnf and added 'user=mysql' to the [mysqld], [mysql.server] and [mysqld_safe] sections. I have also commented out the [safe_mysqld] section. Although mysqld is running as user mysql the mysqld_safe process is still running as root. How do I change this so that mysqld_safe is running as user mysql?
Can't Log In As Anyone But Root. Error 1045
I can GRANT permissions to new users from both the MySQL monitor and phpmyadmin. However, when trying to connect with the new username and password (from either the command line or from a PHP script) I get an error. Here's a copypaste of me logging into the console, adding a user, logging out, and trying to log in as the new user: bash-2.05a$ /usr/local/bin/mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 522 to server version: 3.23.55-entropy.ch Type 'help;' or 'h' for help. Type 'c' to clear the buffer. mysql> grant all -> on * -> to test identified by 'test123' -> ; Query OK, 0 rows affected (0.00 sec) mysql> quit Bye bash-2.05a$ /usr/local/bin/mysql -u test -p Enter password: ERROR 1045: Access denied for user: 'test@localhost' (Using password: YES) bash-2.05a$ Anyone know what's going on? I've googled to no avail.
Root Lost Privileges
My root user lost privileges to the main mysql database. I can only view two databases (information_schema & another custom one). I can't view any users due to having no SELECT privileges. How do I restore the privileges for root back to the defaults?
Changing Root Account
I'm using MySQL 5.0.45-win32. I've read that you should not use the root account, which was installed by default when I set this up. It has a password on it. I'm planning to use another account with less priviledges for a PHP web application, but I'm wondering about the root account. > If I don't use it for the web application but it still exists on the server, does it pose a security threat? > If I change the user name 'root' to something else, will I have difficulty launching the MySQL command line client (because when I run this application now, it only asks for the password (of the root account))? > If I set up this application on a hosted server, I assume I'll need to set up an account for working with the web application that has the domain name of the server - such as hostedServer.com - so that my web access account would be webaccount@hostedServer.com (for example). I assume that I would need to do this whether or not the web server was on the same server as the MySQL database, right?
Reset Root Password Mac OSX 10.3
i can't find the .pid file described in the password reset instructions (or for that matter really understand the instructions)..
Forgotten Root Login.
I need help resetting my root login. I've lost my password. I've uninstalled MySQL and reinstalled it hoping that it would work and no luck. How do I go about doing this? I'm operating on OSX.
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?
Root Password / Startup
I'm using mysql-server-3.23.58-4 on a Linux (Fedora 1) machine, and I'm new to databases/MySQL. After reading the security section of the manual from http://dev.mysql.com, I added passwords for the 'root' accounts. However, now the startup script (/etc/rc.d/init.d/mysqld) fails. I tried adding: [mysql.server] password=xxx into /etc/my.cnf How do I set the password for the startup script ?
|
TRACKER
