Re: Could Not access data base! My SQL?
> 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.
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.