What is MySQL user and database?

Question

Ez Youtube Clone Documentation





===================================

Server requirements:

===================================



1) MySQL (version 4 or higher)

2) MYSQL database

3) PHP (version 5 or higher)

4) GD library for PHP

5) Mplayer + Mencoder (http://www.mplayerhq.hu/design7/dload.html)
6) flv2tool (http://inlet-media.de/flvtool2)





====================================

Installation And Setup Instructions:

====================================





Installation:



1) Extract the zip file containing the software.

2) upload all files to the selected directory.

3) CHMOD 777 all the folders inside "upload" folder.


4) create a new MySQL user and database.

5) Open lib/connect.php file and edit the variables as well as the MySQL parameters.

6) Run SQL/SQL.sql through any of your mysql clients (i.e phpmyadmin)

7) Admin Link: http://yoursite.com/admin

8) Default Admin login:

User: admin
Password: admin

9) Sample User login:

User: userdemo
Password: userdemo

Answer 1

When you install MySQL, as part of the process you also create a root (admin) user.

MySQL is relational database software; you can run a query to create a database in MySQL.



Yes, www.mysql.com is the official MySQL website. You can download MySQL Community Server from there along with MySQL Workbench. All documentation is also on that website.

Answer 2

Mysql is a database program, actually 2 parts, a database server and client program connect to it. Obviously you can NOT just let anyone access this as it leaves no security on your site. So you need to create a user to access the database. DO NOT USE the user root which is the admin user of a mysql database, it makes a big hole in security. Seriously bad advice. Initially the root user has no password and is used to set up the database server. You then need to create a user with appropriate rights to access the data as you want it used. You should then set a password for root to prevent anyone logging in as that user. If you had to ask this you are not ready to add such services to your site. One mistake with security can let a criminal take over your site for their own purposes and this will bring the authorities down on you. Not clever if you are letting people post videos and one of them has posted copyrighted material, you would also be held responsible for that. I suggest before you start you do a search for php manual and mysql manual. Both are available on line. Take careful note of security issues.

Answer 3

Mistaken Syntax: ' $_COOKIE [ ' ID_my_site ' ] ' ) "; you could have a pair of single fees within a par of single charges! Rename the DB subject "text" to "txt" ("text" is a keyword and will lead to confusion, identical a "date" or "desc") Re-write: $cook dinner = $_COOKIE [ ' ID_my_site ' ]; $tit = $_POST [ ' title ' ] ; $txt = $_POST [ ' text ' ] ; $sql = "INSERT INTO `feedback` (`title`, `txt`, `user`) VALUES ( ' " . $tit . " ' , ' " . $txt . " ' , ' " . $cook dinner . " ' ) "; [space added, note difference between ' " ` ] observe: the varaible "txt" may incorporate unique characters, comparable to ', ", ç! You must write: $txt = addslashes ( $_POST [ ' text ' ] ) ; (or some other precautions)