hjf
-
Posts
9 -
Joined
-
Last visited
hjf's Achievements
Newbie (1/14)
0
Reputation
-
This is a link to the close.bat file. I did a search for stop.bat bug fix but couldn't find a file to download.
-
Thanks. I followed the link and realized I needed to set a password. So I followed the link to change the password and managed to follow the instructions for changing the MySQL root password. However, the stop.bat file I have doesn't stop the server. I had to restart the computer. Also, your last instruction "Restart the servers and check access using phpMyAdmin (left menu in apanel)" needs a few more words of explanation because once I get to phpMyAdmin, I don't see anything that tells me where to put the new password. Nevertheless, I retried the script and it worked. Thanks again.
-
I am trying to access MySQL using PHP. I get an error message stating access is denied for user '-uroot'@'localhost'. The '-uroot' and '-proot' worked fine in the MySQL console. Are they different if I'm accessing MySQL using PHP? Here's the part of the code where I put in username and password: <?php /* Program: mysql_up.php * Desc: Connects to MySQL Server and * outputs settings. */ echo "<html> <head><title>Test MySQL</title></head> <body>"; $host="localhost"; $user="-uroot"; $password="-proot"; $cxn = mysqli_connect($host,$user,$password); $sql="SHOW STATUS"; $result = mysqli_query($cxn,$sql); if($result == false) Thanks in advance.
-
Thanks. That will be helpful. Thanks.
-
I find it difficult to locate what I need on the Uniform Server Web site. Are there any manuals on this site? I'm getting a syntax error and I don't know where on this site to find documentation/manual to solve the problem. The error says: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'platform varchar(10)' The code I'm typing in at the mysql prompt is: create table languages ( language_id int unsigned not null auto_increment primary key, name varchar(10), platform varchar(10) ); thanks.
-
Thank you, Ric. It worked this time. thanks for replying. Ric's response helped me. Thanks for replying. I was trying to get the mysql prompt.
-
Ric, I got as far as "Type in CD usr\local\mysql\bin this selects the folder where you run MySQL console". That's the last instruction I understood and accomplished. I don't know why I need to create users and set permissions but I tried to follow the instructions but I can't figure out what I'm supposed to type for the username and password. The instructions are to type mysql -uroot -proot (Where -u stands for username immediately followed by the username...) I tried: mysql -uroot -proot (since I thought "root" was the default and I haven't made any changes) mysql root root mysql uroot proot Each time I get a message: 'mysql' is not recognized as an internal or external command, operable program or batch file. I'm stuck.
-
Thanks, Ric. I'll check it out.
-
I'm following a tutorial to learn PHP. The tutorial is assuming individual installation of PHP, MySQL, and Apache.--not The Uniform Server. The tutorial has an exercise which requires access to MySQL. I'm supposed to type a statement at the mysql> prompt. I can't figure out how to get to the mysql prompt. I don't see any MySQL files in the Uniform Server folder. I used the UniServer admin panel to check if MySQL is running. It is. That's all I can figure out. Any help/direction will be appreciated. Thanks.