SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Thread: MySQL newbie.

  1. #1
    SitePoint Member
    Join Date
    Oct 2000
    Posts
    4
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I have set up MySQL settings with automation scripts through CP's before but my current host does not have this feature so I have to do it manually. My question is, I can set up alot of what I need through phpMyAdmin but I need to know how to add hosts and new users which isnt available in phpMyAdmin. I have tried to find it in the MySQL manual but I cant find anything on adding new hosts and users to the table. Any ideas or help would be appreciated. Keep in mind this will be the first time I do this.

    Thanks

    X-treme

  2. #2
    SitePoint Author Kevin Yank's Avatar
    Join Date
    Apr 2000
    Location
    Melbourne, Australia
    Posts
    2,571
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    Here's the relevant section of the MySQL manual:

    http://www.mysql.com/documentation/m...ge_system.html

    You need write access to the 'mysql' database on your MySQL server to be able to make changes to the access privileges on your database server. It is quite possible that your host has only allowed you access to a single database belonging to you, in which case you cannot grant access to new users and hosts...
    Kevin Yank
    CTO, sitepoint.com
    I wrote: Simply JavaScript | BYO PHP/MySQL | Tech Times | Editize
    Baby’s got back—a hard back, that is: The Ultimate CSS Reference

  3. #3
    SitePoint Member
    Join Date
    Oct 2000
    Posts
    4
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks for the info I figured it out.


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
  •