- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: mysql user is read only and how can I change i...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-09-2003 02:37 PM
тАО06-09-2003 02:37 PM
mysql user is read only and how can I change it ?
I'm using MySQL version 3.23.52 installed on linux SuSE 8.1
mysql> GRANT ALL ON cacti.* TO cactiuser@localhost IDENTIFIED BY 'password';
ERROR 1036: Table 'user' is read only
mysql>
why this user is read only and how can I change it ?
kindly regards
chris
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-09-2003 02:47 PM
тАО06-09-2003 02:47 PM
Re: mysql user is read only and how can I change it ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-09-2003 09:58 PM
тАО06-09-2003 09:58 PM
Re: mysql user is read only and how can I change it ?
with which user were you logged in ?
I think that user had not the capability to write to the "user" table, but only to do a select (select any table privilege).
Massimo
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-11-2003 02:53 AM
тАО06-11-2003 02:53 AM
Re: mysql user is read only and how can I change it ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-11-2003 06:14 AM
тАО06-11-2003 06:14 AM
Re: mysql user is read only and how can I change it ?
thanks.
now is working.
there was a problem with permissions.
regards
chris
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-11-2003 01:54 PM
тАО06-11-2003 01:54 PM
Re: mysql user is read only and how can I change it ?
All permissions on mySQL are managed on 'mysql' database and all the permissions are described on the 'user' table on the base of where you connect from and with which mysql user.
You can have all precise information on that link:
http://www.mysql.com/doc/en/Adding_users.html