Professional Web Applications Themes

New User - MySQL

Hello, I'm using mysql GUI and I don't know how to create a new user. Now I'm entering as a root, but I need a different user to connect to, for my php project. Another thing is that when I connect to the GUI, it tells me the forward: "Either the server service or the configuration file could not be found. Startup variables and service section are therefore disabled". What can this mean?? I'm using Xampp. Thank you a lot!!...

  1. #1

    Default New User

    Hello, I'm using mysql GUI and I don't know how to create a new user.

    Now I'm entering as a root, but I need a different user to connect to,
    for my php project.

    Another thing is that when I connect to the GUI, it tells me the
    forward:
    "Either the server service or the configuration file could not be
    found. Startup variables and service section are therefore disabled".

    What can this mean??
    I'm using Xampp.

    Thank you a lot!!

    kdokdo@gmail.com Guest

  2. #2

    Default Re: New User

    com wrote: 

    MySQL "GUI" doesn't really narrow it down. A good tool for this job is
    "MySQL Administrator". Log in to your database as root using it, go to
    "User administration", and you can add a user. Make sure that you give
    your new user some Schema Privileges for the schemas that it needs to
    access.

    Cheers,
    Nicholas Sherlock

    --
    http://www.sherlocksoftware.org
    Nicholas Guest

  3. #3

    Default Re: New User

    Thank you very much!

    Nicholas Sherlock ha escrito:
     
    >
    > MySQL "GUI" doesn't really narrow it down. A good tool for this job is
    > "MySQL Administrator". Log in to your database as root using it, go to
    > "User administration", and you can add a user. Make sure that you give
    > your new user some Schema Privileges for the schemas that it needs to
    > access.
    >
    > Cheers,
    > Nicholas Sherlock
    >
    > --
    > http://www.sherlocksoftware.org[/ref]

    kdokdo@gmail.com Guest

  4. #4

    Default Re: New User

    com wrote: 
    >>
    >>MySQL "GUI" doesn't really narrow it down. A good tool for this job is
    >>"MySQL Administrator". Log in to your database as root using it, go to
    >>"User administration", and you can add a user. Make sure that you give
    >>your new user some Schema Privileges for the schemas that it needs to
    >>access.
    >>
    >>Cheers,
    >>Nicholas Sherlock
    >>
    >>--
    >>http://www.sherlocksoftware.org[/ref]
    >
    >[/ref]


    Your version will determine the best way to add a new user. If you want to be a
    really good DBA-type -learn to do it from SQL - not just the GUI. Any monkey
    can be taught to point-click their way through the process...

    And most of all - learn to read the doentation. www.mysql.com
    --
    Michael Austin.
    Database Consultant
    Michael Guest

Similar Threads

  1. Replies: 0
    Last Post: February 2nd, 07:00 AM
  2. user levels, cell phones, and user registration, plus cookies
    By Hans Dube webforumsuser@macromedia.com in forum Macromedia Flash Sitedesign
    Replies: 0
    Last Post: January 28th, 08:42 PM
  3. Start Menu - All Programs - All users/Current user (Default user)
    By Gary in forum Windows Setup, Administration & Security
    Replies: 2
    Last Post: August 11th, 05:52 AM
  4. user account does not appear in the user accounts control panel
    By Frank in forum Windows Setup, Administration & Security
    Replies: 0
    Last Post: July 25th, 02:35 AM
  5. Replies: 0
    Last Post: July 9th, 11:13 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