starting XAMPP Questions

[timp]

I was able to install XAMPP to my PC successfully and have been
using it. 2 questions:
How do i change the default username(root) and password to
something else.And how do I access the MySql prompt to practice SQL
commands.

[Wiedmann]

How do i change the default username(root) and password to
something else

The file "readme_en.txt" explains all.

And how do I access the MySql prompt to practice SQL
commands.

Like you can read in the MySQL Manual. The MySQL Command Line Client you can found in the directory "\xampp\mysql\bin".

[timp]

Thanks.

[IamJim]

For Wiedmann please? Or someone?

Thank-you for:

The MySQL Command Line Client you can found in the directory "\xampp\mysql\bin".

I do open fins, and run

> showdatabases;

Total db showing is only (2)
information_schema
test

in XAMPP Control panel using phpMyAdmin I have more.. 11

Please I wonder, why they do not show?

Thank-you.

[Wiedmann]

Please I wonder, why they do not show?

The user you are using for the connection does not have enough privileges to see more.

[IamJim]

Hello Wiedmann, and I thank-you for the reply and I am sorry about my late one. I did not have "notify response" ticked...(sigh)

Regarding your response.

The user you are using for the connection does not have enough privileges to see more.

OS is Windows2kServer
xampp install is from 30 days ago or so.

My local scripts I use:

Code: Select all

define("DB_SERVER", "localhost");
define("DB_USER", "root"); //change when live
define("DB_PASS", ""); // change when live

I am > cmd > cd\xampp\mysql\bin and I run command line > mysql

show databases; = Only 2

does not root , no password on localhost have FULL access?

If databases imported or created with phpMyAdmin, are they stored different? As I have 14 total.

Thank-you.

Jim

edit>> I just now went to cd\xampp\mysql\data and I see this is where ALL fro phpMyAdmin has stored these.

[Wiedmann]

I am > cmd > cd\xampp\mysql\bin and I run command line > mysql
show databases; = Only 2
does not root , no password on localhost have FULL access?

Just using the command "mysql" in the shell, without additional parameters, connects you with an anonymous user, and not with the user "root".

[IamJim]

Thank-you!! Now I feel like an idiot!! (smile)...as for 4-5 years now I have been working mainlyon my remote servers...... And have always, already been logged in...(as root)

Again!! My Thank's...and sorry to bother you.

Jim

[IamJim]

Again, a problem and sorry to post it here:

Solution fine to login and access ALL db's onve I used root as user with no password.

Did it quite a few times yesterday..

Last evening I decided to upate & run SpyBot Search and Destroy.

I also rebooted this morning

Today? Unable to use command prompt to login like yesterady..

What is worse? And big problem? I try XAMPP Panel.. MySQL admin to oopen phpMyAdmin..

and now (cry)

Has anyone run across this?

Welcome to phpMyAdmin

Error
MySQL said:

Cannot connect: invalid settings.

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

[IamJim]

Note to Wiedmann & all

RESOLVED

I am resolved, but strange situation as I stated above. All had been working fine yesterday.

a: I updated Spybot
b: I ran Spybot
c: I reboot

d: I had not run Spybot since XAMPP install, so I am not sure if??

e: Could no longer login

Had to reset mysql permissions

http://dev.mysql.com/doc/refman/5.0/en/ ... sions.html

Again, my thank's to all...but STRANGE

Jim