Hey Sonny,
Don't let the vitriol get you down. Some people just don't like helping newbies... Despite the fact at one time they didn't know anything either.
I'm not sure if I understand your problem to the fullest, but I'll *try* to help you out.
You may have to create a new user in the mysql database itself. There are e-smith specific examples of how to do this, but for the sake of a robust answer, try this:
Assuming you're logged in the e-smith console as root, start mysql by typing "myql"
If you're not, start mysql by typing "mysql -u
-p" and you'll be prompted for a password.
do the following at the mysql prompt:
mysql> use mysql;
mysql> insert into user (Host, User, Password, Select_priv, Insert_priv, Delete_priv, Update_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv) values('localhost', '', PASSWORD('
mysql> flush privileges;
mysql> exit;
What you would have just done is created a new mysql user that has full access to everything. In the PHP scripts, the connection code should be something like:
$link = mysql_connect ('localhost', '', '');
Any PHP script (including your phpmyadmin installation) that contains that connection to the mysql database should have any mysql commands at its disposal.
Personally, I'd forget phpmyadmin unless you are doing a LOT of entries into a database, or will have someone else make your entries. In either case, there are better ways to do these jobs. You could create all of your MySQL entries in a text file, and execute them from the command line (usually something like: mysql < path/to/file.sql)
Further recommended reading:
The MySQL Pocket Reference: http://developer.sapien.net/mysql_pkt_ref/ -- This has all the essential MySQL commands with samples.
HTH
-Quade
6 Replies
719 Views