WampServer

How can I change the default startup for the MySQL console to ask for the user name as well as the password? I'm trying to login as another user instead of root but ' -u username -p ' throws a syntax error. I've tried editing the server user and password settings in the config.ini.php file with no luck. I also haven't been able to find anything that works online.

I found this post on the forum:

[forum.wampserver.com]

but it looks like nobody's found an answer yet. Maybe by now there is one?

Thanks,
plschwenk

you cannot just add new mysql users by editing the config file. you will need to login to phpmyadmin and create the users. why do you need to use the mysql console? you can just do everything in phpmyadmin.

read the phpmyadmin section of my manual. link to my manual is in my sig.



CyberSpatium
----------------------
WAMP English Forum Admin

I have WAMP5 working with (for development use only):
Windows Vista Ultimate x64 (64 bit)
Kaspersky Internet Security Suite 7.0.x
Spyware Terminater 2.x
CounterSpy 2.5.x


Need help? Check out my WAMP User Manual/Guide here!


Web Development for Newbie's Blog - Check out my new blog. It is for web developers, and especially tailored for the web development newbie. If you are not fluent in “geek speak”, then this incredible resource is just you. And even if you are a web development pro, this is a great resource to check out some of the latest web development tips, news, tutorials, codes and more.

I have the new user already created, I want to login to the database as the new user. I'm taking a class where the professor requires all the students to have the same username and password for grading purposes. I will be accessing this database using JDBC and through my program files and I want to be able to manually login to the database to insure that my scripts are running correctly.

Thanks,
plschwenk

if you want to monitor your server you can do it much easier if you use the mysql administrator. if is freeware so you can dont have to pay for it.

[dev.mysql.com]



CyberSpatium
----------------------
WAMP English Forum Admin

I have WAMP5 working with (for development use only):
Windows Vista Ultimate x64 (64 bit)
Kaspersky Internet Security Suite 7.0.x
Spyware Terminater 2.x
CounterSpy 2.5.x


Need help? Check out my WAMP User Manual/Guide here!


Web Development for Newbie's Blog - Check out my new blog. It is for web developers, and especially tailored for the web development newbie. If you are not fluent in “geek speak”, then this incredible resource is just you. And even if you are a web development pro, this is a great resource to check out some of the latest web development tips, news, tutorials, codes and more.

Thanks, I will give it a try. I guess this means that there isn't a way to log on as a different user? I would think that there would be. It doesn't make sense to only be able to log on with just one username.

Anyway, thanks for your time and the advice.
btw, your user's manual is great!! I've passed it on in several of my classes.

Quote

I guess this means that there isn't a way to log on as a different user? I would think that there would be. It doesn't make sense to only be able to log on with just one username.

Yes, it does, and you just need to set it up properly

Have fun,

[test.jlbn.net] (Sample Testing Codes for PHP, MySQL, ASP.net, SQL, JSP)
[www.jlbn.net] (Basic Guide for WAMP & Add-ons)

If you know of a way to set it up to be able to log on as a user other than root, would you mind sharing that information? I've looked through your user manual as well and the information is not in there either.

plschwenk

Check your mail for instruction

Have fun,

[test.jlbn.net] (Sample Testing Codes for PHP, MySQL, ASP.net, SQL, JSP)
[www.jlbn.net] (Basic Guide for WAMP & Add-ons)

Thanks!! Your instructions worked great! I knew there had to be a way. I also appreciate the redirect to the add-on for mysql administrator - the less to configure at installation the better I will also be passing your website along to my classmates.

Thanks again!
plschwenk

You're welcome anytime ;-)

Have fun,

[test.jlbn.net] (Sample Testing Codes for PHP, MySQL, ASP.net, SQL, JSP)
[www.jlbn.net] (Basic Guide for WAMP & Add-ons)

I was searching the internet for a solution to changing the default startup for MySQL console to ask for the username and password, when I came across this forum and realized that you had helped plschwenk with the directives. I am soliciting your help likewise please...
Thanks
Lionking

lionking if you grab teamviewer ill showyou had to add options to the menu.

i have a new exe for wamp, but im not willing to post a link for its download as its a custom project i am working on.

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Steven,

I just want to change the default startup to ask for a username and a password, do you know how to configure wamp to make this happen?
Lionking

no its not possible. Mysql cannot ask for a user, you must supply a username before the dialog opens.


you can change the user it opening with , or you could add two consoles to the menu with different users.

or you can create your own bat file to ask for the details and then open the console -and add this bat file to the menu.

or you could use my new exe that will allow for a user and password before opening the dialog

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Steven,

You said your new exe is work-in-progress, so for now could I configure wamp to startup with a different user a part from root then log-in as a different user at the mysql console instead of at the c prompt eg. c:\wamp\bin\mysql\mysql5.5.24\bin. I want to go to a different user from the mysql console...
Thanks
Lionking

just open c:\wamp\wampmanager.tpl

search for root and replace with your username

save the file, right click wamp icon > refresh

-------------------------------------------------

if you want to add two consoles on the menu.

search for root as above.

then copy that line and paste it on the line after it so you have two lines.

then edit the user and the name ... so for example they would be

Type: item; Caption: "${w_mysqlConsole}(root)"; Action: run; FileName: "${c_mysqlConsole}";Parameters: "-u root -p"; Glyph: 0
Type: item; Caption: "${w_mysqlConsole}{user2)"; Action: run; FileName: "${c_mysqlConsole}";Parameters: "-u user2 -p"; Glyph: 0


save the file, right click wamp icon > refresh

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]



Edited 2 time(s). Last edit at 10/18/2012 08:06PM by stevenmartin99.

Steven,

Thanks very much, I aslo made some changes to c:\wamp\wampmanager.ini and it works. Now, how do I switch to another user from mysql console
Thanks,
Lionking

You dont need to make changes to the ini file.

Just the tpl file . And press refresh which will rebuild the ini file.


You cannot change user from the mysql console. Mysql never built it this way.

If you did what I said , you will have two options on the wamp menu where you can open it with different users

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Steven,
Thanks, so in order to facilitate multiple users, I have to go through the c prompt on localhost or my maindrive on a remote server
Thanks
Lionking

Nooo!!! Ur confusing yourself alot, can you get Teamviewer please

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]



Edited 1 time(s). Last edit at 10/19/2012 04:10PM by stevenmartin99.