Hello,
I have 3 users in my MySQL server. One of them has Grant access
(actually: all privileges). I cannot login as this user using
phpMyAdmin - my password is not accepted (though I' m sure it must be
the right one).
I CAN login as any of the other users. When I do this and choose
'privileges' I get the overview:
User - Host - Password - Global Privileges - Grant - Action
I can see the user with all privileges, but the cell under 'Host' is
empty. Does this mean this user cannot login from any host?
Since I am now logged in as a limited user, having no Grant
privileges, I can't change this...
As far as I understand, I have locked myself out of the server and
don't know how to get in...
Is there any way I can get back in?
Thanks,
Marc 3 2694
On 3 Jan 2004 07:21:54 -0800, me**********@yahoo.com (Marc) wrote: I have 3 users in my MySQL server. One of them has Grant access (actually: all privileges). I cannot login as this user using phpMyAdmin - my password is not accepted (though I' m sure it must be the right one).
I CAN login as any of the other users. When I do this and choose 'privileges' I get the overview: User - Host - Password - Global Privileges - Grant - Action I can see the user with all privileges, but the cell under 'Host' is empty. Does this mean this user cannot login from any host?
Since I am now logged in as a limited user, having no Grant privileges, I can't change this...
As far as I understand, I have locked myself out of the server and don't know how to get in...
Is there any way I can get back in?
Log in as the root user and alter the passwords?
--
Andy Hassall (an**@andyh.co.uk) icq(5747695) ( http://www.andyh.co.uk)
Space: disk usage analysis tool ( http://www.andyhsoftware.co.uk/space)
Hi,
I can log in as root but then I don't have the 'Privileges' link I
would have when log in as one of the other users. It says 'No
Privileges'.
On Sun, 04 Jan 2004 02:28:52 -0800, Marc wrote: Hi, I can log in as root but then I don't have the 'Privileges' link I would have when log in as one of the other users. It says 'No Privileges'.
Great! 8)
Regards,
Ian
--
Ian.H [Design & Development]
digiServ Network - Web solutions www.digiserv.net | irc.digiserv.net | forum.digiserv.net
Programming, Web design, development & hosting. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: |
last post by:
I issued the mysql command
Grant all on *.* to myid@localhost identified as "mypw";
and recieved the error message
ERROR 1045: Access denied for user" '@localhost' (Using password: NO)
I...
|
by: Bruce A. Julseth |
last post by:
I am doing something wrong or have something set up wrong.
When I issue
mysql> grant all on * to mike identified by 'joented' with grant
option;
Query OK, 0 rows affected (0.69 sec)
It...
|
by: Amardeep Verma |
last post by:
Hi,
I have a quick question. Which role/privileges are required before
a user can give the statement "GRANT ALL PRIVILEGES"?
Thanking you in Advance
Have a nice day
|
by: Charles Cantrell |
last post by:
I have recently set up mySQL on a Mandrake release of Linux (Version 7 of
Mandrake, I believe), using the binary 4.0.13 standard release.
The set up and start up all were normal, as far as I...
|
by: Charles Cantrell |
last post by:
I have recently set up mySQL on a Mandrake release of Linux (Version 7 of
Mandrake, I believe), using the binary 4.0.13 standard release.
The set up and start up all were normal, as far as I...
|
by: maxwell |
last post by:
mysql Ver 3.23.54
Having read, as best I could, the docs at http://www.mysql.com/documentation ...,
on host (Linux from scratch, kernel 2.4.20) "mysql.here.com" I enter:
mysql> GRANT ALL...
|
by: Xerxes |
last post by:
When I use the following GRANT statement
GRANT SELECT , INSERT , UPDATE , DELETE ON sassisc.* TO
sassisc@localhost IDENTIFIED BY 'dodge3'
it came back with an error message:
SQL-query :
...
|
by: Marc |
last post by:
Hello,
I have 3 users in my MySQL server. One of them has Grant access
(actually: all privileges). I cannot login as this user using
phpMyAdmin - my password is not accepted (though I' m sure it...
|
by: nomad |
last post by:
Hello Everyone.
I need some help in create Privileges for a new db.
I'm using a host call addr.com and I hate them for there cpanel sucks.
any I hav to write a MySQL to Grant All Privileges for a...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |