Topic: MySQL

[eManX01]

I am trying to set up a small online store using zencart. Zencart asks me for SME Server's database username and password. What do I need to do to change the database username and password? I would also like to know how to update PHP and MySQL. Thanks.

[eManX01]

I would also like to know if the CD-RW on my server can be used by the PCs on my network and if so how?

[syx]

for the phpmyadmin question, go here  
http://no.longer.valid/phpwiki/index.php/phpMyAdmin

download and install that, restart your server and then go to yourserver.com/phpmyadmin

to setup your database stuff.

I dont know to update mysql and php. Are you sure you need to ?

Theres a contrib on here somewhere that allows you to share that cd drive. have a search and you'll find it.

 

[eManX01]

I really appreciate you actually responding, but phpMyAdmin says it can't access MMySQL because it doesn't know the MySQL username and password. Where can I find the username and pasword and how can i create and/or change the username and password. I am running Windows XP Home. I don't know how to access SME server through Windows Command Promt either.

[syx]

so you have installed the phpmyadmin rpm on your sme server ?

If you have its just a matter of pointing your browser to yourdomain/phpmyadmin

From there you can set up the usernames and passwords.

The default user name is admin adn the password is whatever you specified during the install.


As far as accessing your sme server from another machine running windows you have to connect using ssh. You can do this with 'putty' which is a free program (google is your friend). There are instructions on how to configure putty on this site somewhere.

There are also instructions on how to create a new samba share so that you can access certain parts of your server from your windows boxen using windows explorer.

Hope this helps

[eManX01]

How do i install the rpm. I've been downloading the zip file and extracting it into the html folder.

[syx]

its easier to work on the SME server.
Once your downloaded the rpm file and put it on the server, it doesnt really matter where, you need to use the rpm commadn to install that rpm.
rpm is equivilent to setup.exe for windows users.

using the mc command navigate to the folder that contains the rpm on your sme server. typically /home/e-smith/ibays/someibay/somedirectory/

then type
rpm -ivh *.rpm

this will install and .rpm files in that directory (you will most likely only have one)

then you restart the server (im not sure this is nessesary) and everything is hunkydory

[eManX01]

how do i get to the command prompt on SME server?

[syx]

push alt+f2 to go to a second terminal, then if your then at the screen with all the blue on it you need to select the logout option. If not then you can log in as root and the admin password and then you should get a normal prompt.

hope that helps some more

[eManX01]

thanks a bunch so far. I got into the command prompt, but when i type in where the rpm is, SME says that it cannot be found. i typed in "cd /home/e-smith/files/users/eman/". I then type "rpm -ivh *.rpm"

[syx]

type in mc at the command prompt, this will start the midnight commander, use this navigate to the corrent directory.

[eManX01]

how do i get out of mc?

[syx]

press f10

[eManX01]

now how do i get to phpmyadmin through a web browser? I tried www.mydomain.com/phpmyadmin and it gave me "403 Forbidden, You don't have permission to access /phpmyadmin on this server." What do I do. It didn't even ask me for the username and password

[nmtrier]

Did you try https://www.mydomain.com/phpmyadmin ?
                ^
                |