Tx u for your reply and reply shows u understand question. When I am a newbie, u pose a question base on lack of knowledge with intent to learn more. I am very happy u took the time to reply - priviledge.
As a newbie, I play with create db for the application. Play with create table. The other stuff, glance, so cannot recall details. Curretly, I have decided phpmyadm is a good tool and need to learn more. Prior, tried looking for easy way out of mysql ( utility and tools for db stuff for I am not db but more programmer)
There is no easy way out and phpmyadm is > it < after searching and using other stuff with nothing comparable. Offline, application development user (self training), sole user limited knowledge. Current step of having 2 or 3 gnu install, interface, and then write my application working in unison. Difficult for a first timer.
Info on privliedge needed for editor or helpers. Tx again for your insight. When I use application, there iis db_connect ( server, db, username, password). Server is localhost, db is a required db for that application (note: db created in phpmyadm - create db - ie, db exist for that application), username is root which I used to in xAMPP, PHPMYADM, AND created db, password is password used in xampp, phpmyadm). What I inquired about is having different username, and password from my xampp and phpmyadm. Currently, master user and password.
With priviledge, I create user and assign that user a password. Now, I can create a lower level user with a newly assigned password. So, slayergirl u answered my question.
Db connect (localhost, dbname, loweruser, lowerpassword).
How to get this: MYSQL> ? To execute mysql command Sql monitor.
Go to coomand line and type mysql ( Equivalent to DOS prompt and type mysql????). Would need to experiment and have better understanding of mysql commands. I know phpmyadm have insert, del and to generate php code. Another way to implement sql command at lower level ( less phpmyadm interface to improve learning experience).