Jump to content
The Uniform Server Community

hjf

Member
  • Posts

    9
  • Joined

  • Last visited

Previous Fields

  • Main OS
    Windows Vista

hjf's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. hjf

    username/password problems

    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.
  2. hjf

    username/password problems

    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.
  3. 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.
  4. Thanks. That will be helpful. Thanks.
  5. 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.
  6. hjf

    Accessing MySQL

    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.
  7. hjf

    Accessing MySQL

    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.
  8. hjf

    Accessing MySQL

    Thanks, Ric. I'll check it out.
  9. hjf

    Accessing MySQL

    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.
×
×
  • Create New...