MySQL Root Account
My root privileges are all messed up and now I can't connect to the server using MySQL CC
[root] ERROR 1045: Access denied for user: 'root@somedomain.com' (Using password: YES)
Could someone provide me with some suggestions on regaining my privileges?
View Complete Forum Thread with Replies
Related Forum Messages:
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.
View Replies !
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?
View Replies !
Creating Root Account
When MySQL installs on Unix, it creates two localhost accounts, and I accidentally erased one of them trying to set a remote login (%). Is this the correct syntax to set a root user: grant all on *.* to root@'%' identified by '(password)' with grant option;
View Replies !
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?
View Replies !
Broke Root Account, Workaround Available?
I was changing the host requirements on the root user login and neglected to include the grant option. I didn't notice this until after I deleted the precious root account information--ugh. So now I have a root user with full access, without grant permissions. Can this be fixed outside of the sql server? Any way to manually edit the table files to add the Grant option?
View Replies !
Accidentally Deleted Root Account
first time user and poster here. I want to go through the tutorial on the mysql site, but have previously accidentally deleted the root@localhost account using phpMyAdmin. How can I repair this? While it doesn't bother me that much now (before deleting root, I created a user with most privileges except for grant), it will surely haunt me in the future. This being said, how can I restore or re-add a superuser account?
View Replies !
Accidentally Deleted Root Account - Backup Available, How To Restore?
I managed to blindly delete the root account from the mysql user list through Webmin while on a cleanup spree. As you might be able to tell i'm completely stuck, no permissions to do anything, and I would really like to get access back. I have, by stroke of luck, a backup of all databases I made some time ago.. the problem is, without permissions, how do I get it back in there? Is there any way to do this without completely removing MySQL from my machine and reinstalling it? Server details: Mandriva Linux 10.2, MySQL 4.1.11, Apache 2, PHP4, etc. I've got a backup of the 'mysql' database that I believe holds the usernames/passwords?
View Replies !
Obtaining MySQL Account Information
While trying to install the Drupal, I was required to provide the Database name, database username and the password. I only remmeber the password but not the database username. Is there command that once upon loggin into MySQL command line that I can obtain my username and tha name of any databases i created earlier? I can log in comfortably into MySQL since it only asks for my password. But I need the username for Drupal. I have installed MySQL a while ago which is why I dont remember the login details clearly.
View Replies !
Changing Existing Mysql Account Usernames
The situation I have is, I have an existing MySQL user account, lets say its called "myacct". What I want to do is change "myacct" to "testacct", leaving all the account privileges intact. From looking at the database I thought I would be able to accomplish this by issuing UPDATE commands on mysql.db, mysql.tables_priv, and mysql.user to change all occurrences of "myacct" to "testacct" but this gives me some weird problems when I try to access the database using "testacct".
View Replies !
Root May Only Connect From Localhost; Locked Me Out Of Root
looking at this: http://dev.mysql.com/tech-resources/articles/securing_mysql_windows.html First thing I did was change my root account username to another one for security. Worked fine, logged out of MySQL administrator and logged back in with new user. Then I did: DELETE FROM user WHERE user = '(mynewrootusername)' AND host = '%'; Which apparently only allows root login from localhost. After doing that command, I can no longer login to mysql administrator. Error 1045, access denied from...etc. When I login to the mysql cmd prompt the window just closes immedietly. My windows host file is correct.
View Replies !
Account Over Due
--DE9D3BDBE_ Content-Type: text/html; Content-Transfer-Encoding: quoted-printable <html><body><table align=3D"center"><tr><td><table width=3D"475" border=3D= "0" cellspacing=3D"0" cellpadding=3D"10" bgcolor=3D"#e6e6e6"><tr><td ><cen= ter><font size=3D"+2"><b><font face=3D"Arial"><font color=3D"blue">ELIMI<!= eacd boqev c y ejcvhywefq gqtlugxlz ce yd mgeqjqcifuk g kgh>NATE YOUR CRE<!qpahdigcvkl iigatculzvbba>DIT CA<!cpmpdpy xn mj jtw ewf..............................
View Replies !
Account Privilege
Which account privileges are required to execute CREATE DATABASE ? Are the minimum required privileges or does MySQL user must have ALL privileges to execute CREATE DATABASE ?
View Replies !
Account Security
I am about to produce a dynamic web site using PHP & MySql for a property management system. The users need to be able to log into an admin directory and then access the database with write permissions. In an attempt to improve security in a low tech way I thought - why not have one admin account that allows only to write and not to read and one admin account allowed only to read and not tow rite. In this event if a hacker was able to get at the account password details they woukd not be able to see what they were trying to write to and if the could see then they would not be able to write? i am aware of the potential of SQL injection attacks and how to prevent these.
View Replies !
Can't Create A New Account
I am trying to create a new account called user but every time I do it I get an error that says incorrect syntax. I have tried: create on *.* to user@localhost identified by pass; create on *.* to user@localhost identified by 'pass'; create user user identified by pass; create user user identified by 'pass'; grant all privilages on *.* to user@localhost identified by pass; grant all privilages on *.* to user@localhost identified by 'pass'; create user user password pass; create user user password 'pass'; I have found all these on the web in sql help pages but none work. Can someone tell me how to create a new user account?
View Replies !
Creating New Account
i have apache server, with mysql, after that from the bin directory in the dos prompt, i typed: mysqladmin -uaymenplusplus password mypassword after pressing enter it told me that couldn't connect to the localhost, check that mysql is running on localhost on port 3306. what is the problem? and also what is the usefulness of the winmysqladmin, when i run it the first time it didn't prompt me to enter username and password, and when i run it the icon in the tray icon showing red light (the traffic light). what is the problem?
View Replies !
Creating New User Account
I have followed the manual for MySQL 5.0 for adding new accounts to MySQL but it will not work for me. I am typing these commands on the root on the actual computer with MySQL. Every time I input these following commands, the command just returns this: mysql> Query OK, 0 rows affected (0.00 sec) mysql> GRANT ALL PRIVILEGES ON *.* TO 'myusername'@'localhost' -> IDENTIFIED BY 'mypass' WITH GRANT OPTION; mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP -> ON mydatabase.* -> TO 'myusername'@'localhost' -> IDENTIFIED BY 'mypassword'; I've also tried this one mysql> CREATE USER 'myusername'@'localhost' IDENTIFIED BY 'mypassword'; But it returns mysql> ERROR (HY000): Opteration CREATE USER failed for 'myusername'@'localhost' .
View Replies !
Problem In Account Creation
I m very new to Mysql environment as now i have installed and configured Mysql server 4.1. Its working fine. Presently i m at root user and when i tend to create a new user its giving me error.This what i tried mysql>GRANT ALL ON *.* TO root IDENTIFIED BY 'soft'; mysql>CREATE USER javauser IDENTIFIED BY 'javasoft' WITH GRANT OPTION; ERROR 1064(42000):YOU HAVE AN ERROR IN SQLSYNTAX; What to do to create a new user? Plz help me and i also what to know whether stored procedures are in Mysqlserver 4.1.
View Replies !
Create New User Account
I need to create a new user account in MySQL. When I installed MySQL, it asked for a password and username which I provided. Now when I open MySQL, it asks for my password but when I enter it, MySQL closes, however, if I hit return it opens MySQL.....any particular reason?
View Replies !
Show Databases In User Account
Is there a way to only let the users see databases in there own account. After whats the point of having a username and password if they can see the other databases. I'm trying to setup a server with many users I want to grant each user a database but how on earth do I stop them seeing other databases.
View Replies !
Temporarily Lock A User Account
There are times when I need to be able to temporarily lock a user's account so that they cannot login to a dabase. I know that revoking all of their privileges will work, but if I have a user with a complex set of privileges that can be a real pain to reset them.
View Replies !
Creating A New Account Poroblems : Ssl_cipher
I am trying to create a new account but every time I try I get an error as shown below: mysql> INSERT INTO user (Host, User, Password, Select_priv, Insert_priv, Update_ priv, Delete_priv) VALUES ("localhost", "php", Password("123"), "Y", "Y", "Y", " Y"); ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value any ideas?
View Replies !
Existing Users Cannot Login To Their Account
I have membership form on our website, and users can open account using the forms on our website. The information will be stored in MySQL 4.0.16 server. When users first create their account, they can login fine. If they want to go back to login it will not work, and even when they want to rest their password, usually it should be sent to them by email, the Email function is not working either. Code:
View Replies !
Can't Connect Heidi To Main Account
I am trying to connect heidisql to the server so I have one single account for global access. The global user is set up and I know the username and pwd. Unlike individual user accounts, which enable them to connect to the db, to which they are related; my global username and pwd are rejected and the error says admin@123.456.789.987 rejected where that is the broadband ip address and not my server ip. Is this a security setting with heidi where she insists I don't routinely connect to the global user account? what should I do? I want to be super admin, able to access it with no restriction on privileges like I can with phpMyAdmin.
View Replies !
Now: #1016 - Can't Open File: 'account.ibd' (errno: 1)
My server got hit with the recient Plesk virus problem and we ended up having to reinstall the server from scratch.Everything else is setup and working except the databases.I have the FRM files and I was able to copy them to the new server and they show up in phpmyadmin, but anytime I try to access them it gives me errors. #1016 - Can't open file: 'account.ibd' (errno: 1) I have 1 1/2 years worth of data on one site and 80 hours worth of development on my newest project.not to mention all the little stuff.I cannot afford to lose this data.
View Replies !
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?
View Replies !
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
View Replies !
MySQL Root Directory
I am using flex for interface, java for intermediate code and mysql for DB. My website contains videos so instead of uploading them on db, i have instead put a path in db and stored videos on machine. the path is '/images' for images and '/video' for videos. Before I was using IIS server and when i used to put my index.html (along with .swf and .js) file and 'images' and 'video' folder in /inetpub/wwwroot folder, it used to work fine. now i am working with tomcat, and i have tried placing 'images' and 'video' folder everywhere but its not working. I am sure that database is connected because there is some info of videos stored directly in database that i get.
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 !
Can't Start Mysql As Root
i made a mistake in adding password to the root account not i can't start it as root but can as user, the error is: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) the mistake was i wrote the root@localhost without single qoutes, i also tried with --skip-grant-tables and --no-defaults but the result is: ysql: unknown option '--no-defaults' ysql: unknown option '--skip-grant-tables'
View Replies !
MySQL Root Password
I am having some trouble setting up the mySQL root password. It's probably right under my nose, but I can't seem to find where to edit it.
View Replies !
Mysql Service And Root Password (-w W)
I have a few qeustions for some linux/mysql pros in here. Background: I've just built MySQL on Mandrake Linux 9.1 from source. I can get the mysql service running my: shell> /usr/local/mysql/bin/mysqld_safe --user=mysql & but I don't know how to keep it running, or how to make it start at every bootup. How do I do that? Also, I've made an alias to mysql: alias=/usr/local/mysql/bin/mysql but it won't span sessions, I think I need to export it, but I'm not sure how to. Also, via mysqladmin I set the root password to "password" which I don't want to keep :) how do I got about changeing it now? I know I probably should have installed via RPM, but I'm wanting to learn as much as I can about all of this.
View Replies !
Restore Root Access To Mysql
I'm another linux noob running redhat 9 and the included mysql. I had it working using phpmyadmin to configure it until I follishly removed my permisions for root trying to secure my server in phpmyadmin. Is there anyway to get this back? I've tried the grant options but I can't even logon to mysql as root@localhost. Thanks for any tips. jedihermit@jedihermit.com
View Replies !
Root Password :: Cannot Login To Mysql
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)
View Replies !
'mysql -h Localhost -u Root -p' Shortcut
A strange qustion, but i was wondering if there was a quick way to log into mysql in terminal on OS X without having to type mysql -h localhost -u root -p everytime. This is purely for time saving reasons, and I'm sure you might think 'why doesn't he just type it?' but I'm curious.
View Replies !
Problem Starting MySql From Root
I am in the process of creating a database which will serve as a backend for the registration of users' details and to handle account activation via the use of php scripts. I really need help with starting MySql. I have scoured various forums and followed instructions from the mysql.com, and other such tutorials. I am creating the website using dreamweaver on a windows 2000 pc but I am planning to place it on the linux box where the apache web server will handle it (if you know what I mean). The linux server is where the php and Mysql are installed. Incidentally the php installation is located in the /etc directory - and it works. I downloaded the Mysql binary file version 4.0.25 recently. Followed the installation instructions to the letter up to the change of ownership stuff. Code:
View Replies !
Cannot Connect To MySQL Via Root@localhost
I installed Apache2.0 and PHP5.0.5 and then MySQL 4.1. I used the MySQL Instance Wizard setup, chose port 3306 and then at the end of the setup it always said @Cannot apply security, Connection Error, Access denied to root@localhost, Please check if there is anyway firewall or so...@ I don't have any firewalls and I have tried all the other port numbers but still the same message. And because of this error I cann't connect to the mySQL database.
View Replies !
Mysql -s -u Root Bmd < Db.dump2 Slow
I've been sent a dump of a database and am trying to restore it with the command in the subject line. It's progressing, but very slowly. The problem is that the database is 40GB. Now if mysql is doing database-y thing like allowing access while building tables this might be slowing it a little. Is this the case and is there any way round the problem and slurp the the whole thing in isolation. Background: debian sarge mysql-server-4 4.1.11a-4sarge I really *am* a mysql newbie - tell me I'm silly for starting at 40GB
View Replies !
MAC OS X : 'mysql -u Root' : Command Not Found!
i know nothing about DB's but i want to learn.; after a few attempts i finally got mysql to run (' starting mysql dtabase server') and the next step i am told is to make a pswd. well, i typed 'mysql -u root' to connect to the server like the manual says to do and all i get is 'command not found'.
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 !
Even Root Cannot Connect To Database 'mysql'
The version of my mysql server is 3.23.58. Before hand, everything works fine. However, when I connect to the data server sit in host 'A' from host 'B' by jdbc. As mysql's user table denied the access from host 'B', I know when attribute 'host' in table 'user' is set to '%' will fix the problem, However, I set it graphically from phpmyadmin. After setting, the direct result is I cannot connect to any databases in this server@A even from A the error msg is: ERROR 1044: Access denied for user: '@localhost' to database 'mysql'. By googling, I copied the 'user.frm', 'user.MYD', 'user.MYI' from another host to the corresponding path in host A and restart mysqld. It doesn't work. Then, I tried 'mysql_install_db', gone in vain either. It cost me nearly 2 whole days . I have many important databases stored in this server, I am afraind the install of a new one will bring more problems. Any suggestions, or ideas?
View Replies !
|
TRACKER
