linux :: xunil

Collected linux snippets

Saturday, March 01, 2008

Adding mysql admin user

Needed to add an admin to the mysql db and couldn't remember how:
Log in with admin credentials from a root login
sudo -s
mysql -uadmin -p`cat /etc/psa/.psa.shadow`
Then:
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
Posted by Unknown at 2:06 pm
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2011 (9)
    • ►  April (1)
    • ►  March (2)
    • ►  February (6)
  • ►  2010 (7)
    • ►  September (2)
    • ►  July (1)
    • ►  June (3)
    • ►  May (1)
  • ►  2009 (8)
    • ►  December (1)
    • ►  September (2)
    • ►  August (4)
    • ►  June (1)
  • ▼  2008 (19)
    • ►  December (2)
    • ►  November (2)
    • ►  October (3)
    • ►  September (1)
    • ►  August (2)
    • ►  July (5)
    • ►  June (1)
    • ▼  March (2)
      • MySQL optimisation
      • Adding mysql admin user
    • ►  February (1)
  • ►  2007 (35)
    • ►  December (5)
    • ►  November (3)
    • ►  September (2)
    • ►  August (2)
    • ►  July (1)
    • ►  June (1)
    • ►  May (4)
    • ►  February (3)
    • ►  January (14)
  • ►  2006 (26)
    • ►  December (2)
    • ►  November (5)
    • ►  October (2)
    • ►  September (4)
    • ►  August (1)
    • ►  July (4)
    • ►  June (7)
    • ►  May (1)

About Me

Unknown
View my complete profile
Awesome Inc. theme. Theme images by fpm. Powered by Blogger.