I've installed mysql 5.5 to work with php.From the workbench I tried to connect first time,
impossible.I've allowed the program through the firewall,nothing.I read all the tutorials on the
subject, still I don't understand one thing. How do I set admin privileges if I cannot connect?
If I run the scripts on the command prompt I get error. Some tutorials talk about installing
Wamp or other software, why do I need more junk on my pc to have the damn mysql working?
And when they talk about the shell, where is the damn shell on the workbench?If I go to start, MySQL,MySQL Server 5.5.,Command Line Prompt it disappears immediately, so where do I type the script?
I like my sql express and management studio better, do I need mysql to work with php?
Getting frustrated.Thanks for your help.
Jump to Post
Have you tried to use mysqladmin?
mysqladmin -uroot password your_password -h localhost
If you are using Windows browse to the directory which contains the tool and add the extension .exe to mysqladmin command, it should be something like
cd \Program Files\MySQL\MySQL server5.0\binand then:
All 2 Replies
We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.