[quote:]MySqlcon.php3 on line 13[endquote]
If you look into the MySqlcon.php3, you might see definitions there that you have to change, if you are happy enough to connect as root without a password, then change the definitions at the top of the file (usually).
Normally you would set:
host as localhost
dbuser as a user you have defined in the MySQL database
dbpassword is the password you have defined for the user above
The easiest way to manage MySQL is to use something like Webmin or MyPHPAdmin scripts. You can find these utilities on the net: I know that you can pick up Webmin from
www.webmin.org. CAUTION: e-Smith does NOT recommend that you use this, as improper use can damage your e-Smith installation irreperably! So be careful, unless you know what you're doing.
If you are not experienced, then use MyPHPAdmin, safer!! (sorry, I'm not being condecending, I don't know your level of experience, so please don't take offence!)
One you are using either of the above utilities, it is easy enough to go to the MySQL section (under the Servers section in Webmin) where you can create the database and manage its users and their access rights.
Also check if your application or script comes with an *.sql file to create your tables, if you do, then create the database, assign username and privileges and then create your tables using the sql file provided:
mysql -uusername -ppassword database < database.sql
Where username is the name you defined, password is the password assigned and database is the database you created, database.sql is the provided sql text file for creation of the tables. Note also that there is no space between the -u and username, -p and password.
Hope this helps
regards
Mahmood
4 Replies
601 Views