Stupid question : How to create a MY SQL database

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Doctor Dre
    Too lazy to set a custom title
    • Jan 2001
    • 51692

    #1

    Stupid question : How to create a MY SQL database

    How to create a MySQL database under windows . Trying to install v bulletin on a windows machine . Never done that b4.
    Originally posted by rayadp05
    I rebooted, deleted temp files, history, cookies and everything...still cannot view the news clip. All I see is that fucking gay ass music video from "Rick Roll". Anyone else have a different link to the news clip?
  • JamesK
    hi
    • Jun 2002
    • 16731

    #2
    install php and mysql on it.
    M3Server - NATS Hosting

    Comment

    • jwerd
      Confirmed User
      • Jun 2003
      • 1953

      #3
      Download MySQL, install it - set it all up...then download phpmyadmin (www.phpmyadmin.net)...I reccomend using Apache (www.apache.org) for the web server... and of course you will need PHP (www.php.net)...then you're set!
      Yii Framework Guru - Seasoned PHP vet - Partner @ XXXCoupon.com

      Comment

      • Doctor Dre
        Too lazy to set a custom title
        • Jan 2001
        • 51692

        #4
        I already got everything I need installed. What I need is too create a database.
        Originally posted by rayadp05
        I rebooted, deleted temp files, history, cookies and everything...still cannot view the news clip. All I see is that fucking gay ass music video from "Rick Roll". Anyone else have a different link to the news clip?

        Comment

        • extreme
          Confirmed User
          • Oct 2002
          • 2120

          #5
          mysql> create database x;
          mysql> show databases;
          mysql> grant all on x.* to drdre identified by 'hellyeah';

          ?

          Comment

          • yanglike
            Confirmed User
            • Jan 2003
            • 183

            #6
            from your admin cpanel or whatever you are using you might have access to phpMyAdmin... that is easiest way for you to create a database.

            if not then open up a php page in your browser and put that code in :
            mysql_query("CREATE TABLE my_table");
            Go Traffic Cash Gold !!!

            Comment

            • FrankWhite
              Confirmed User
              • Nov 2002
              • 3540

              #7
              /usr/local/mysql/bin/mysql -u root -p
              create database databasenamegoeshere;
              GRANT SELECT,ALTER,INSERT,UPDATE,DELETE,CREATE,DROP ON databasenamegoeshere.* TO usernamegoeshere@localhost IDENTIFIED BY 'passwordgoeshere';

              Comment

              Working...