473,480 Members | 5,031 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

One last one mysqladmin

# whoami
root

Yet

shell> mysqladmin -u root password 'yourpassword'
shell> mysqladmin -u root -h yourhost.com password 'yourpassword'
mysqladmin: unable to change password; error: 'You must have privileges to
update tables in the mysql database to be able to change passwords for
others'

Yet I've logged in as root

Sorry again but I would really like to know how permissions are set. I'm
only used to how perms are set in the shell not MySql please explain.

Jul 19 '05 #1
0 1277

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
5227
by: Saravanan Kulandaivelu | last post by:
--------------B23FB769A9677B05B30099D1 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, I am getting the following error: mysqladmin: connect to server at...
0
1400
by: marko2 | last post by:
# whoami root Yet shell> mysqladmin -u root password 'yourpassword' shell> mysqladmin -u root -h yourhost.com password 'yourpassword' mysqladmin: unable to change password; error: 'You must...
0
1497
by: Randell D. | last post by:
Folks, I've been using MySQL 3.23 for a number of months - I've got familiar with the everyday stuff (read/write/sort) but access or grant management still remains foreign. After a recent...
2
1871
by: Jitesh K Patil, Systems Engineer, Wipro Technologi | last post by:
Hi All, I am new to mysql. Please let me know where can I find mysqladmin in the linux file system. I have mysql-3.23.41-2 rpm installed. Most of the mysql bin files are installed in /usr/bin,...
1
1734
by: invinfo | last post by:
Years ago there was a version like this. Was it WinMySQLAdmin ? (I'm on Windows XP and using MySQL 5.0.4-beta-nt) and I see mysqladmin is now just CL driven with a command argument, to be...
3
2007
by: AndyBell | last post by:
Hi all! I have an Access 2000 database for the Habiat for Humanity where I work. This is the second database I have written and it gets a bit more complex each time... I have learned much and...
2
3249
by: Kevin Burton | last post by:
I don't think I understand the last() function. I have a document that looks like: <Root> <Header>Some text</Header> <Message> <MessageID>1</MessageID> . . . . </Message>
15
43537
by: rajbala | last post by:
hi all, I got the error like $ mysqladmin -h localhost -u root -p create bedrock Enter password: ****** mysqladmin: connect to server at 'localhost' failed error: 'Access denied for...
4
2754
by: tsmike | last post by:
I've looked for hours on the internet for a cure, but to no avail. I've tried reinstalling many times but I can't seem to open mysqladmin or any of the other applications in the /bin directory....
5
10372
by: stmfc | last post by:
i am trying to use mysql db for the first time. i have installed mysql-noinstall-5.0.45-win32.zip to my pc. although i didnt have set any password, when i try to login for mysqladmin user via...
0
6905
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7041
Oralloy
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,...
0
7080
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
6736
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...
0
6908
tracyyun
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...
1
4772
isladogs
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...
0
4478
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
1
561
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
178
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.