as administrator you have to type
and then it will ask for your password in the terminal to go inside the folders.
mysql has several folders which are read/write only to user mysql.
you may need to add /usr/local/mysql/bin to your path.
you may want to enable root
and then you wouldn't have to keep typing sudo, but as a self-proclaimed newbie...sounds dangerous to your file system.
once you get your path to recognize the mysql interactive command line binary, then you can perform some test operations with mysql.
if you have php and apache working, then you still have to add the mysql password to the phpMySQlAdmin configuration files.
if you have never seen it operating chances are there is no password. even you gave a password to the system.
There is a discussion of this issue in the mySQL docs.
once you create users with passwords in mySQL then you can enter those passwords into the phpmySQLAdmin interface.
try mysql with no password.
you should have the mysql directory set something like this
drwxr-xr-x 37 root wheel 1214 Sep 29 17:18 bin/
drwxr-xr-x 3 root wheel 264 Sep 29 17:18 include/
drwxr-xr-x 3 root wheel 264 Sep 29 17:18 info/
drwxr-xr-x 3 root wheel 264 Sep 29 17:18 lib/
drwxr-xr-x 3 root wheel 58 Sep 29 17:18 libexec/
drwxr-xr-x 10 root wheel 296 Sep 29 17:18 mysql-test/
drwxr-xr-x 3 root wheel 264 Sep 29 17:18 share/
drwxr-xr-x 23 root wheel 738 Sep 29 17:18 sql-bench/
drwx------ 17 mysql wheel 534 Oct 6 23:17 var/
where the data files are in the var directory.
unless you have allfilesvisible set to tru you will never see this stuff in the finder anyway.
when making the users for mysql or postgres it is good to use a no priveliges user like nobody or unknown as the template.
(means use <b>command-d</b>(Duplicate) in the Netinfo manager)
you can still can give a shell and a home directory, but make sure they are having the correct ownership or you will get errors when you start those users.
there are many things which you need to study up on...
so, it makes it difficult to answer.
The easy answer is make sure mysql binaries are in your path, start the mysql binary.
log in issue a few commands assign yourself a password.
the YES is the value you are throwing to the binary meaning, I assume .....the user really has no password but you are passing a password parameter.
Therefore the Value of password cannot be "yes". (because no password is defined for the user in question) Also, has that user name been configured in mySQL?
If you did these things before on a web interface, the guy who set it up did a few things in advance to make it easy for you.
Now you just have to read the manuals by your self.
everytime you don't know what something is... either ask in the forums or go to
99% of all questions have been asked and answered on some forum or FAQ posted on the net.