Hi to all whos reading this! This is my first time posting here, and the reason why im creating this post s bcoz I got big problem with SME 7.2.
I actually got 2 major problems here.
1st is the "how to access the MySQL server" and 2nd is the "how to install PhpMyAdmin in SME 7.2".
I've gone through the whole day searchin in dis forum for answers to those 2 problems that I have and none seem to have helped. My problems are somehow similar to the other posters, but I guess there are just some specific steps I need to know to be able to followthrough this. So anyways lemme tel u guys wat i knw and what I've done in trying to resolve these problems.
First of all, I'm a newbie in Linux, but gettin a little hang of it since some of the commands are similar to windows commands(which I'm very familiar of). Second I'm also a newbie in SME. And have some intermediate lvl of knowledge in MySQL.
Useful Information:
-My friend was the one who setup the SME server 7.2 and we've been using it as our webhost server for our project for a couple of months now. All of our html files that we uploaded to the webserver didnt have any php and database coding. They are just pure html and css. Now we want to upload our php files to the webserver and configure our MySQL database. And my friend dont know how to with the MySQL. The php end on the SME server already works via locally or the internet, also includes the ftp.
1st thing that I did, tried to access the mysql from the OS shell command line. Typed in mysql and it gave me an error message prompting "Access is denied for user 'root'@'localhost' (using Password:no) and returns me to my prompt [root@r10-iserver /]#. Then I followed these steps as to what I've read to some of the posts here. To reset the mysql root password.
cd /var/service/mysqld
runsvctrl d .
expand-template /root/.my.cnf
expand-template /var/service/mysqld/set.password
/usr/libexec/mysqld --bootstrap --user=mysql --skip-grant-tables < ./set.password
runsvctrl u .
I restarted the service of mysql just to be sure and used the command "service mysqld restart", prints out [OK]. I tried to reset the password, but can't seem to get the commands right. Here's the command that I followed, at the shell i typed in "cd /var/service/mysqld" and pressed enter. Now the command line changes to [root@r10-iserver mysqld]#. Then I typed in "runsvctrl d .", but gets an error of "command not found". So I instead used "sv d ." as to what some posters have said due to the changes of the SME version or sumthin. And after trying that nothin happens. Next, I used this command "expand-template /root/.my.cnf" and also says command not found. I tried removing the hyphen and used this command instead "expand template /root/.my.cnf" and now shows me the 75 alphanumeric character root password. Then I encoded this "expand-template /var/service/mysqld/set.password
/usr/libexec/mysqld --bootstrap --user=mysql --skip-grant-tables < ./set.password", this long command didnt work. Just kept on giving me command not found. But still encoded the last line in the end "sv u ." and the command line just moves on the next line. I then tried to access mysql again by typin in the mysql just to chek f there were any changes. But to a dissapoint still denied me to access it.
I havent tried accessing the mysql iputting the -uroot and -prootpassword coz I dont know the exact command with it. Like where do I put the 75 characted password. Actually, I have tried it but just gave me a bunch of errors. So this is with my 1st problem, cant access mysql.
Now to my next problem, I don't know how to install a phpmyadmin rpm in the SME server 7.2. I logged in to the Server Manager of SME and checked for the installed softwares in the server and found out that there wasnt any PhpMyAdmin installed. So I checked the updates, and noticed that there werent any PhpMyAdmin in the updates as well. So it came to my mind just to download the file an rpm contrib site. Then it came to me, "Where the hell do I put the downloaded rpm?". I mean, in accessing the server manager UI console, I use a different computer with xp as its OS. I downloaded the rpm for the PhpMyAdmin using the xp computer. I accessed the server files but I cant seem to find the folder files for the SME. So how do I go about this? Can any of u guys help. I badly need it...