Professional Web Applications Themes

user problem - MySQL

Hi all I made a stupid mistake in mysql using webmin. I accidently deleted root user in mysql. On the linux PC i add user root to the mysql group. when i want to add a new database in mysql using webmin a message access denied for rootlocalhost how can i set back the root user in mysql so root have permission again in mysql ? thanks in advance...

  1. #1

    Default user problem

    Hi all

    I made a stupid mistake in mysql using webmin. I accidently deleted root
    user in mysql. On the linux PC i add user root to the mysql group.

    when i want to add a new database in mysql using webmin a message access
    denied for rootlocalhost

    how can i set back the root user in mysql so root have permission again in
    mysql ?

    thanks in advance


    Anja en Ad v Meersbergen Guest

  2. #2

    Default Re: user problem

    try this

    GRANT all privileges on *.* to 'root''localhost' identified by
    'rootpassword';

    flush privileges;

    Visu Guest

Similar Threads

  1. Question User Authentication Problem
    By eazy2all in forum ASP
    Replies: 0
    Last Post: March 14th, 03:24 AM
  2. user control problem access value from user control to a page
    By gauravkg via DotNetMonster.com in forum ASP.NET Building Controls
    Replies: 3
    Last Post: September 18th, 01:06 AM
  3. User controls problem.
    By Josema in forum ASP.NET Building Controls
    Replies: 1
    Last Post: January 19th, 05:39 AM
  4. Problem with web user control
    By oterox in forum ASP.NET Building Controls
    Replies: 1
    Last Post: November 26th, 06:54 PM
  5. User control problem
    By John in forum ASP.NET Building Controls
    Replies: 5
    Last Post: October 31st, 06:19 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139