MySQL Forums
Forum List  »  Newbie

Re: Could Not access data base! My SQL?
Posted by: Rick James
Date: July 17, 2014 03:57PM

> how to actually connect this database to the website?

mysql> USE mydatabase;

> I also don't understand how to make a schema for this databse.

mysql> CREATE TABLE mytable ( ... );

There are a zillion examples of CREATE TABLE in this forum, plus some in the mysql.com documentation.

I prefer the 1-liner for giving access:
GRANT ALL PRIVILEGES ON mydatabase.* TO 'myname'@'localhost' IDENTIFIED BY 'mypwd';
Where 'localhost' could, instead, be an IP address or hostname ('mysite.com') or certain wild cards.

Options: ReplyQuote


Subject
Written By
Posted
Re: Could Not access data base! My SQL?
July 17, 2014 03:57PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.