Results 1 to 2 of 2
Thread: MySQL new user question
Jul 17, 2002, 17:00 #1
- Join Date
- Jul 2002
- Odenton, Maryland
- 0 Post(s)
- 0 Thread(s)
MySQL new user question
Already established a connection to MySQL from PHP page thanks to Kevin Yank.
However, now wish to use "Thatware" on web server as a learning exercise.
PC in question is running RHL 7.3, Apache, MySQL 3.23.51 and PHP 4.1.2.
It seems logical to me that I need to establish a non root account in MySQL and grant privileges. Perhaps I have this wrong but is it smart to continue using a connection that calls localhost/root/password from any PHP page on the web server?
What is the correct sequence of commands at the "msql" prompt to create a new database for this use. Also, what commands are needed to create a new user account if required.
Lastly if the grey matter is still on tap, is "Thatware" a suitable candidate for my setup.