Install PHPAdmin on Abyss Web Server Version2

ve1alq

Hi Folks; I just recently purchased Abyss Web Server2
I am having difficulty getting phpAdmin to function on Abyss Server Version 2.
I have read the Instructions asking me to go to Control Console>Server Configuration>Advanced>.....But there is no Advanced???
Any Help please, Regards & Thanks, DGW
ve1alq@nbnet.nb.ca
_________________
Darrell G Ward

TRUSTAbyss · - Joined: 29 Oct 2003 Posts: 3752 Location: USA, GA

You are probably reading an out dated tutorial , I recently upgraded my new
website to work with the new Abyss Web Server v2 , go to my website. LateR!

Abyss Web Server: Tutorials
www.TRUSTAbyss.com

btos · - Joined: 10 Feb 2006 Posts: 15

I followed along in the trustabyss tutorial until the third page on your php admin tutorial. You allow no room for explanations of any ERRORS, of which there are many in trying to undersand this complex coding set-up. I got an error #1045 stating a username and password problem from MySQL. No explanation to be found anywhere for solving the new riddle! Yet another dead end and waste of time. I learned asp quickly compared to this. :?

TRUSTAbyss · - Joined: 29 Oct 2003 Posts: 3752 Location: USA, GA

I made a mistake by telling people to delete the already created users
and now in the newer versions, it completely messes up the phpMyAdmin
setup process. Please try the new updated tutorial and see if it helps.

The screenshots should guide you on where to put your information. Just
follow the examples given in the screenshots and it will work out just fine.

The screenshots are there to show you where to put things, that way you
don't have to worry about the complex config.inc.php file. My installation
guide is completely accurate. It explains everything you need!

I can help you on MSN Messenger if you want.
My MSN: msn@trustabyss.com

Sincerely, TRUSTpunk

btos · - Joined: 10 Feb 2006 Posts: 15

I was going for a clean install. No usernames and passwords are known in MySql... How can I set up usernames and passwords within that program and get php to let me use it? As I said, that issue never came up during install...that I can remember. I've been at this for quite awhile and have to take it in smaller bites...quite an elephant to eat.

TRUSTAbyss · - Joined: 29 Oct 2003 Posts: 3752 Location: USA, GA

Setting up Usernames and Passwords in MySQL is very advanced, it's all
based on command line. Add me to your MSN Messenger and I will help
you with your phpMyAdmin script. You'll get it working, don't worry.

My MSN: msn@trustabyss.com

Sincerely, TRUSTpunk

btos · - Joined: 10 Feb 2006 Posts: 15

That is why phpMyAdmin is needed. Isn't it used to set up usernames and passwords in MySQL? I need to do that and set up a database name but cannot, according to a 1045 error, after I followed installation from the tutorial. I looked for an explanation of the error on the MySQL website and found a long list of common errors...with no explanation of ANY solutions. PHP and MySQL are both programs that you can die trying to learn...it just takes too long to get it working...then you are supposed to get to the fun part...creating stuff. From what I've seen, I'm not impressed. The MySQL theme seems to be keep em confused and they will pay for help. :?

Jam · - Joined: 24 Mar 2006 Posts: 1

Hi all,

If I'm not wrong regarding this error, it may certainly comes from the fact since version 4.1.7 of MySQL the encrypting method for password as changed. I know there are solution, but I don't know where to find it.
I've got the same problem trying to install a personnal Joomla 1.0.8 on AWS with PHP 4.4.2 + MySQL 5.0.18. My main problem is that I allready have database running and I don't want to setup again everything.

If someone knows how to, please share.
Jam

aprelium · - Joined: 22 Mar 2002 Posts: 6800

Jam,

To get New MySQL versions > 4.1 work on PHP, you'll have to use the new MySQLi extension which seems to be available only on PHP 5.

Sure there is a solution but it's very complex and involves a lot of MySQL tweaking: we recommend reading http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html for more information about the "old passwords" feature.
_________________
Support Team
Aprelium - http://www.aprelium.com

ozzy214 · - Joined: 31 Mar 2006 Posts: 66

Hey punk I read your guide awsome job. But Im concerned. I keep getting this message

Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole.

BTW the looks of your tutorial we are leaving mysql with no password, but have the server lock phpmyadmin. Am I right?

TRUSTAbyss · - Joined: 29 Oct 2003 Posts: 3752 Location: USA, GA

That message is normal. phpMyAdmin creates the MySQL user account for
you, so that's why I say to skip the Password for root setup. You should be
able to use Abyss Web Server to protect access to /phpadmin.

ozzy214 · - Joined: 31 Mar 2006 Posts: 66

Ok then can you tell me how to do it the right way instead of abyss protecting it? Every i create a pass for root it screws up and locks me out. I rather have phpmyadmin locked instead of the server locking it. Thisd way if a hacker comes round and breaks the server pass...they cant get to the databases.....

TRUSTAbyss · - Joined: 29 Oct 2003 Posts: 3752 Location: USA, GA

The tutorial is updated so that you don't have to get locked out. Older
versions allowed you to delete the extra users that MySQL created, but
since the new versions arrived, you cannot delete them.

Just add a new user after installaing MySQL from the phpMyAdmin
interface and that will solve the problem. If you would like any kind
of help regarding this problem, here's my MSN.

My MSN: msn@trustabyss.com