how to access the database?

[alexlega]

hello all,

I would like to flush the sample data that came with my installation.
I am used to phpmyadmin.

I have installed sugarcrm normally, run it as a service but I don't know where to access phpmyadmin/mysql database...
I am used to Easyphp when it comes to using phpmyadmin and it seems I can get to it when SugarCRM is running. (I guess SugarCrm is running Apache + mysql and Easyphp is trying to do the same thing...)

so: do you guys know how i can access the database using phpmyadmin please?

(I have also copied phpmyadmin to apache2/htdocs but when I am trying to open it in my browser I have an error message)

thanks!

[pblag]

Hi!

As i see you use Windows for sugarcrm.
There can be few bugs so 1 apache wasn't installed as service.

if Sugarcrm works i do recommend to use one of the old version of phpmyadmin
Also you have to configure config file.
Put there your mysql information and everything will be ok.

BTW: what error do you see?

[alexlega]

hi pblag and thanks for taking the time to answer me.

I just managed to access phpmyadmin (config problem apparently)
the only problem remaining is that, when I want to select the "sugarcrm" database from the drop down menu on the left hand side of phpmyadmin no info is displayed but "Unable to connect").

I sitll can see the sugarcrm database on the drop down menu though (103 tables)

any idea please?

thanks!

[Markku]

Hi,

If removing sample data is the main issue here then I'd suggest you to re-install Sugar and during install uncheck "install sample data" option.

Please read this thread as well:
http://www.sugarcrm.com/forums/showthread.php?t=12686

I would like to flush the sample data that came with my installation.

[ivolator]

Why don't you install MySQL GUI tools for windows.

http://dev.mysql.com/get/Downloads/M...m/pick#mirrorshttp://dev.mysql.com/get/Downloads/M...m/pick#mirrors
much better on windows to use this.




But wait there is more as they say in the commercials.
This is the hard way. Who needs the hard way ?

In windows you can access mysql without phpMyAdmin.
1.Locate your mysql installation
2. cd to the bin directory
3. type mysql -uYOURUSERNAME -p YOURDATABASENAME
4.at the prompt enter the password
5. TRUNCATE TABLE yourtablename

Of course you'll have to type it for each table., but the good news is that not many of the tables have much data anywas ....