SitePoint Sponsor

User Tag List

Page 1 of 2 12 LastLast
Results 1 to 25 of 42
  1. #1
    SitePoint Enthusiast
    Join Date
    Dec 2001
    Posts
    30
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Stuck on Kevin's Mysql installation instructions

    I followed the firections and installed it in the directory just like he said. However I am stuck at the point to where you want mysql to start whenever the sytem is running

    If you want your MySQL server to run automatically whenever the system is running (just like your Web server probably does), you'll have to set it up to do so. In the share/mysql subdirectory of the MySQL directory, you'll find a script called mysql.server that can be added to your system startup routines to do this
    I looked but I dont have that file at all and because I dont have that file I cant do the next step which is Setting up your system to run the script at startup

    I was able to do the next step which is create a
    my.cnf file in /etc

    As long as I can turn it on whenever I want so can someone tell me what to type to start it whenever I want in a way that will work with Kevin's tutorial

  2. #2
    SitePoint Enthusiast
    Join Date
    Dec 2001
    Posts
    30
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Um believable, not one answer.

    Can some at least tell me how to make a database with a password to the database

    I want to install vbulletin

  3. #3
    Mlle. Ledoyen silver trophy seanf's Avatar
    Join Date
    Jan 2001
    Location
    UK
    Posts
    7,168
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    What Operating System are you using?

    Sean
    Harry Potter

    -- You lived inside my world so softly
    -- Protected only by the kindness of your nature

  4. #4
    Gone!
    Join Date
    Aug 2001
    Location
    Witty Location Parody
    Posts
    3,889
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by Kaiser_Sose
    Um believable, not one answer.

    Can some at least tell me how to make a database with a password to the database

    I want to install vbulletin
    From what I remember from when I installed it, you create a user ID and password at installation, making you the administrator for editing databases etc.

    Did you do that?

  5. #5
    SitePoint Wizard samsm's Avatar
    Join Date
    Nov 2001
    Location
    Atlanta, GA, USA
    Posts
    5,011
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Your questions are out of my area of expertise so I am hesitant to answer. However, I do deal with this kind of stuff so maybe I can help.

    I assume from context that you are installing on a Lynux system... when I installed on Mac OSX (UNIX varient) I followed a different set of instructions and never needed to do thestep that troubled you (as far as I remember). I think it is probably a good idea to find and follow the directions for your particular system rather than the article's instructions which are a bit vague.

    Before I blunder into making new users for mySQL, do you have the mySQL client running yet and have you set a new root password using mysqladmin?

  6. #6
    Dumb PHP codin' cat
    Join Date
    Aug 2000
    Location
    San Diego, CA
    Posts
    5,460
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Move the share/mysql.server file to your /etc/rc.d/init.d folder

    CHMOD a+x on it.

    Then make a symlink from /etc/rc3.d to the mysql.server file in the init.d file. Make the symlink name whatever as long as it starts with S then a number look in the folder to see what I mean. You will see a bunch of symlinks like S99cron S50blah the number represents the order in which the programs will be started. So as a sample.


    ln -s ../init.d/mysql.server S98mysql
    Please don't PM me with questions.
    Use the forums, that is what they are here for.

  7. #7
    Dumb PHP codin' cat
    Join Date
    Aug 2000
    Location
    San Diego, CA
    Posts
    5,460
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    BTW the mysql.server file is located in the share/mysql folder of the mysql distro. So whatever the root for the mysql tree is its in there.
    Please don't PM me with questions.
    Use the forums, that is what they are here for.

  8. #8
    SitePoint Enthusiast
    Join Date
    Dec 2001
    Posts
    30
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I installed PHp 4.10, Mysql 3.23.46 and Phpmyadmin on RH 7.2 on a computer on my LAN

    I followed Kevin's instructions

    From the command line I know how to make a databe, that was described in the tutorial. But how do you give the database a username and password

  9. #9
    SitePoint Enthusiast
    Join Date
    Dec 2001
    Posts
    30
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by glenplake


    From what I remember from when I installed it, you create a user ID and password at installation, making you the administrator for editing databases etc.

    Did you do that?
    You create that for the Mysql server itself not for a specific databse

  10. #10
    Dumb PHP codin' cat
    Join Date
    Aug 2000
    Location
    San Diego, CA
    Posts
    5,460
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by Kaiser_Sose
    I installed PHp 4.10, Mysql 3.23.46 and Phpmyadmin on RH 7.2 on a computer on my LAN

    I followed Kevin's instructions

    From the command line I know how to make a databe, that was described in the tutorial. But how do you give the database a username and password
    Log in as root

    GRANT [PRIVS] on dbname.[tables] to username@[host] identified by '[password]'

    follow it up with a flush privileges;


    Example

    GRANT all on mydb.* to username@localhost identified by 'mypass';

    flush privileges;


    Which would give all prives to a user named username on localhost whose password is mypass
    Please don't PM me with questions.
    Use the forums, that is what they are here for.

  11. #11
    SitePoint Enthusiast
    Join Date
    Dec 2001
    Posts
    30
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Well, I just installed vbulletin using "root" as the pusername and the mysql server "password" as the the vbulletin databse password

    If I wanted to install other scripts that require a database name, username, and password can I just use the same database username and password on a different database name - if not - thats why I ask how do you create a databse with a database username and password

  12. #12
    Dumb PHP codin' cat
    Join Date
    Aug 2000
    Location
    San Diego, CA
    Posts
    5,460
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Are my instructions above not clear enough?
    Please don't PM me with questions.
    Use the forums, that is what they are here for.

  13. #13
    SitePoint Wizard samsm's Avatar
    Join Date
    Nov 2001
    Location
    Atlanta, GA, USA
    Posts
    5,011
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yes, "root" can have access to any number of databases and should work fine as a user for any script... from what I understand, you'd only setup a different user as a security precaution.

    Anyone correct me if I've got a case of the wrongs.

  14. #14
    Dumb PHP codin' cat
    Join Date
    Aug 2000
    Location
    San Diego, CA
    Posts
    5,460
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    In a test env using root to access your databases is fine. However if you are gonna make this a production machine, please for you own sake give root a password and create users without grant or drop privs for your indivdual databases.
    Please don't PM me with questions.
    Use the forums, that is what they are here for.

  15. #15
    SitePoint Enthusiast
    Join Date
    Dec 2001
    Posts
    30
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You can use the test database (if you have access to it) for the examples that follow, but anything you create in that database can be removed by anyone else with access to it. For this reason, you should probably ask your MySQL administrator for permission to use a database of your own. Suppose you want to call yours menagerie. The administrator needs to execute a command like this:

    mysql> GRANT ALL ON menagerie.* TO your_mysql_name;

    where your_mysql_name is the MySQL user name assigned to you.
    Well, I found these instructions on the Mysql site as well

    So what you are saying is, if I had a databse called menagerie I would put
    PHP Code:
    GRANT ALL ON menagerie.* TO "username"
    This is of course ony if i had a database called manegerie already made

  16. #16
    Dumb PHP codin' cat
    Join Date
    Aug 2000
    Location
    San Diego, CA
    Posts
    5,460
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yeah if you wanted that user to have every priv imaginable and no password then yes.
    Please don't PM me with questions.
    Use the forums, that is what they are here for.

  17. #17
    SitePoint Enthusiast
    Join Date
    Dec 2001
    Posts
    30
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by freddydoesphp
    Yeah if you wanted that user to have every priv imaginable and no password then yes.
    Oops, I forgot the password. So is this correct

    PHP Code:
    GRANT ALL ON menagerie.* TO "username" identified by'password'
    I am a little lost. What if I wanted to install PHPnuke or similar on the Linux computer on my LAN where I set this all up. Vbulletin is currently installed with the database username and password that the Mysql server is, which is 'root' and 'password'.

    Now how do I make another database, give it a username and password because the config.php script for Phpnuke (just like vbulletin) asks for them



    Thanks for all your help

  18. #18
    SitePoint Author Kevin Yank's Avatar
    Join Date
    Apr 2000
    Location
    Melbourne, Australia
    Posts
    2,571
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    You misunderstand. MySQL databases don't have usernames and passwords assigned to them. MySQL users have passwords assigned to them, and are granted access to particular databases.

    Therefore, to install PHPNuke, you'll need to create a new database for it. Then you can either grant access to that new database to an existing MySQL user, or create a new MySQL user specifically for the database.
    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

  19. #19
    SitePoint Enthusiast
    Join Date
    Dec 2001
    Posts
    30
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hello Kevin:



    What about the original problem I had and posted in the first question. In my share/mysql subdirectory of the MySQL directory I dont have a file called mysql.server

    What I have is a bunch of different languages folders and three files none are the one I need

    Look here



    So how do I get mysql to start with the system



    Thanks

  20. #20
    Dumb PHP codin' cat
    Join Date
    Aug 2000
    Location
    San Diego, CA
    Posts
    5,460
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hey whats your email address I'll send you a copy.
    Please don't PM me with questions.
    Use the forums, that is what they are here for.

  21. #21
    SitePoint Enthusiast
    Join Date
    Dec 2001
    Posts
    30
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    mb797@yahoo.com

    Please give directions on what I should do



    Thanks

  22. #22
    SitePoint Author Kevin Yank's Avatar
    Join Date
    Apr 2000
    Location
    Melbourne, Australia
    Posts
    2,571
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    Hmm I'll have to install the latest version of MySQL on my Linux box to see what they did with the mysql.server file...
    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

  23. #23
    SitePoint Enthusiast
    Join Date
    Dec 2001
    Posts
    30
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by kyank
    You misunderstand. MySQL databases don't have usernames and passwords assigned to them. MySQL users have passwords assigned to them, and are granted access to particular databases.

    Therefore, to install PHPNuke, you'll need to create a new database for it. Then you can either grant access to that new database to an existing MySQL user, or create a new MySQL user specifically for the database.
    Then to sum up can you

    • give the code to make another mysql user

    • give the code to give that user a password

    • give the code to make that new user's database (unless that new database should already be made)


    Thanks all

  24. #24
    SitePoint Author Kevin Yank's Avatar
    Join Date
    Apr 2000
    Location
    Melbourne, Australia
    Posts
    2,571
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    Just out of curiosity, have you bothered reading the chapter in the MySQL manual on all this? Your questions still reflect a half-wrong impression of the MySQL access privilege system, and I think a good hour spent reading up on it would really be worth your while.
    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

  25. #25
    SitePoint Enthusiast
    Join Date
    Dec 2001
    Posts
    30
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    OK, I will do that when I get some time

    I just thought a quick one line answer to each would be helpfull

    Can someone e - mail the file I am missing. Otherwise I wont know how to start the mysql server independently of the linux computer


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
  •