Topic: Logging in to a text console instead of server-manager

[Lars Krasuski]

Is that possible, and how?

I need to create some databases but I cant seem to find a way to log in without getting a menu, with predefined options...

Tried with phpMyAdmin, but it wont work .. what is the default password to MYSQL, or DO I have to make permissions in the console first - haow do I do that...

Sorry for the many questions, but I cant find it written any obvious places in the manual...

[Dan Brown]

http://edocs.mitel.com/6000_SME_Server/smeserveruserguide/English/console-rootprompt.html
http://www.familybrown.org/howtos/mysql-password-howto.html

[TV2]

Hi,

I've also experienced some problems concerning phpMyAdmin.

I did the following:
 - Made a login on the SME server as root
 - Then I followed this:
http://www.mysql.com/doc/en/Adding_users.html#IDX545

created a new user with all privileges and used that userid in phpMyAdmin config.inc.php

Remember of course to set up a userID in mysql that already is created in SME as a regular user, just to avoid any problems.

My problem was that I couldn't get access to anything concerning mysql through phpMyAdmin even if I used root as user and supplied the correct password.
By default root haven't got full access privileges to mysql, only locally, certainly not through phpmyadmin.

So, don't drop phpMyAdmin - IT IS GREAT AND FREE SOFTWARE!

Hope this help, otherwise you are welcome to write again.

/tv2

[TV2]

Hej igen Lars

Ha ha - Så lige efter jeg havde postet, at du faktisk var fra kære danmark. Men smid mig en mail hvis det ikke lykkedes dig at få phpMyAdmin op at køre på trods af min vejledning.

Det kan lade sig gøre... jeg har fået det til at køre på SME v 5.5

Hilsen
TV2

[Dan Brown]

On the contrary, TV2, the _mysql_ root user does indeed have full access.  You almost certainly did _not_ use the correct password, however--it's completely different from the normal root password.  Check out http://www.familybrown.org/howtos/mysql-password-howto.html for some additional information.

Also, when adding a MySQL user, there's no reason to use a username that's already in use in the SME server--mysql users are entirely separate from system users.

[TV2]

Hi again,

Alright alright....

But what I did worked so........