Changing the password, and creating a database

[Evil Glint]

I've searched the internet for days, and tried many things, but to no avail. Can anyone please help me:

• set the root password and
  
• create a database?
  

I'm running an iMac OS X 10.4.11 with a 400 MHz PowerPC G3 processor. It has PHP version 5.2.4 and MySQL version 5.1.40 for OS X10.4 PowerPC. Everything I try fails. I've tried using Sequel Pro, but it they says

Error.

Couldn't create database.

MySQL said: Access denied for user ''@'localhost' to database 'icebb'

(I tried to make a database called "icebb")

I also tried PHPMyAdmin (which wouldn't even let me log in), and several commands entered into Terminal. Any ideas?

[trq]

Can you access MySql as the root user?

[Evil Glint]

I should be able to, as I am the root admin (and only user) of my computer, but every time I try to, I get error messages, or access denied messages. (I'm probably just using bad syntax or something.)

[trq]

(I'm probably just using bad syntax or something.)

 

Can you show us then?

[Evil Glint]

Using "/usr/local/mysql/bin/mysql" or the regular Terminal.app:

$ mysqladmin -u root password this-is-my-password

and

create database icebb;

The former acts like it's an incomplete code, and drops down to the next line when I hit enter, the latter outputs:

ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'icebb'

[trq]

If your trying to login as root you need to use roots password. If you haven't set a password for root yet, it may be still blank. Try....

 

mysql -uroot

 

at a terminal.

[Evil Glint]

Try....

 

mysql -uroot

 

at a terminal.

I get:

-bash: mysql: command not found

[fenway]

then "locate" mysql and run it from there.

[Evil Glint]

I tried that as well, but it just when to the next line when I hit enter, waiting for the next line of the code. I also tried ending the code with a semicolon, but it complained about syntax errors near mysql -uroot.

[fenway]

I tried that as well, but it just when to the next line when I hit enter, waiting for the next line of the code.

That means you're successfully logged in to the mysql client...

[Evil Glint]

If I type the code to create a database next, I get:

mysql> mysql -uroot

    -> create database icebb;

ERROR 1064 (42000): 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 'mysql -uroot

create database icebb' at line 1

mysql>

 

[trq]

mysql -uroot

 

will get you to a prompt. (mysql>) if your already at a prompt it will cause errors because it is not part of a valid command / query.

[Evil Glint]

When I don't have "mysql>" it complains thea "mysql -uroot" has bad syntax, and won't execute. Whether I have it or not, it won't execute: "$ mysqladmin -u root password this-is-my-password;", "$ mysqladmin -u root password 'this-is-my-password';" or "create database icebb;" all tried with and without the semicolon.

[fenway]

That doesn't make sense -- you got to the "mysql>" client prompt.

[Evil Glint]

I only get the "mysql>" client prompt when I open Terminal by opening the file: "file:///usr/local/mysql/bin/mysql" (not by entering a command).

[trq]

Indeed. Then once at a prompt you should be able to create databases.

[Evil Glint]

Once at that prompt, entering: "create database 'icebb';" will result in

ERROR 1064 (42000): 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 ''icebb'' at line 1

and "$ mysqladmin -u root password 'password';" will result in

ERROR 1064 (42000): 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 '$ mysqladmin -u root password 'password'' at line 1

[Pikachu2000]

Database and table names don't get enclosed in quotes. If you enclose them, use `backticks`. String values get quoted.

[trq]

Also, mysqladmin is a terminal command, not a mysql one. This means it will work at your Bash prompt not the mysql one.

[Evil Glint]

I can't get it to function at the bash terminal or the mysql terminal.

 

My computer is having problems now (it keeps freezing). It's never done this before. I think all the errors I keep getting might be causing this. I may have to give up, and reinstall the operating system without MySQL. It's shame, but I may need to run PHP (which is working) without the enhancing power of databases.

[trq]

You probably can't get mysqladmin to work because its not on your execution path for whatever reason. Same as mysql wasn't on your execution path.

 

Have you tried using the full path to the executable?

 

/usr/local/mysql/bin/mysqladmin

[Evil Glint]

/usr/local/mysql/bin/mysqladmin

outputs:

Last login: Mon Dec  6 13:44:35 on console

Welcome to Darwin!

x:~ X$ /usr/local/mysql/bin/mysqladmin

/usr/local/mysql/bin/mysqladmin  Ver 8.42 Distrib 5.1.40, for apple-darwin8.11.0 on powerpc

Copyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc.

This software comes with ABSOLUTELY NO WARRANTY. This is free software,

and you are welcome to modify and redistribute it under the GPL license

 

Administration program for the mysqld daemon.

Usage: /usr/local/mysql/bin/mysqladmin [OPTIONS] command command....

  -c, --count=#      Number of iterations to make. This works with -i

                      (--sleep) only.

  --debug-check      Check memory and open file usage at exit .

  --debug-info        Print some debug info at exit.

  -f, --force        Don't ask for confirmation on drop database; with

                      multiple commands, continue even if an error occurs.

  -C, --compress      Use compression in server/client protocol.

  --character-sets-dir=name

                      Directory where character sets are.

  --default-character-set=name

                      Set the default character set.

  -?, --help          Display this help and exit.

  -h, --host=name    Connect to host.

  -b, --no-beep      Turn off beep on error.

  -p, --password[=name]

                      Password to use when connecting to server. If password is

                      not given it's asked from the tty.

  -P, --port=#        Port number to use for connection or 0 for default to, in

                      order of preference, my.cnf, $MYSQL_TCP_PORT,

                      /etc/services, built-in default (3306).

  --protocol=name    The protocol of connection (tcp,socket,pipe,memory).

  -r, --relative      Show difference between current and previous values when

                      used with -i. Currently works only with extended-status.

  -O, --set-variable=name

                      Change the value of a variable. Please note that this

                      option is deprecated; you can set variables directly with

                      --variable-name=value.

  -s, --silent        Silently exit if one can't connect to server.

  -S, --socket=name  Socket file to use for connection.

  -i, --sleep=#      Execute commands again and again with a sleep between.

  --ssl              Enable SSL for connection (automatically enabled with

                      other flags). Disable with --skip-ssl.

  --ssl-ca=name      CA file in PEM format (check OpenSSL docs, implies

                      --ssl).

  --ssl-capath=name  CA directory (check OpenSSL docs, implies --ssl).

  --ssl-cert=name    X509 cert in PEM format (implies --ssl).

  --ssl-cipher=name  SSL cipher to use (implies --ssl).

  --ssl-key=name      X509 key in PEM format (implies --ssl).

  --ssl-verify-server-cert

                      Verify server's "Common Name" in its cert against

                      hostname used when connecting. This option is disabled by

                      default.

  -u, --user=name    User for login if not current user.

  -v, --verbose      Write more information.

  -V, --version      Output version information and exit.

  -E, --vertical      Print output vertically. Is similar to --relative, but

                      prints output vertically.

  -w, --wait[=#]      Wait and retry if connection is down.

  --connect_timeout=#

  --shutdown_timeout=#

 

Variables (--variable-name=value)

and boolean options {FALSE|TRUE}  Value (after reading options)

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

count                            0

debug-check                      FALSE

debug-info                        FALSE

force                            FALSE

compress                          FALSE

character-sets-dir                (No default value)

default-character-set            (No default value)

host                              (No default value)

no-beep                          FALSE

port                              0

relative                          FALSE

socket                            (No default value)

sleep                            0

ssl                              FALSE

ssl-ca                            (No default value)

ssl-capath                        (No default value)

ssl-cert                          (No default value)

ssl-cipher                        (No default value)

ssl-key                          (No default value)

ssl-verify-server-cert            FALSE

user                              (No default value)

verbose                          FALSE

vertical                          FALSE

connect_timeout                  43200

shutdown_timeout                  3600

 

Default options are read from the following files in the given order:

/etc/my.cnf /etc/mysql/my.cnf /usr/local/mysql/etc/my.cnf ~/.my.cnf

The following groups are read: mysqladmin client

The following options may be given as the first argument:

--print-defaults        Print the program argument list and exit

--no-defaults          Don't read default options from any options file

--defaults-file=#      Only read default options from the given file #

--defaults-extra-file=# Read this file after the global files are read

 

Where command is a one or more of: (Commands may be shortened)

  create databasename  Create a new database

  debug                Instruct server to write debug information to log

  drop databasename    Delete a database and all its tables

  extended-status      Gives an extended status message from the server

  flush-hosts          Flush all cached hosts

  flush-logs            Flush all logs

  flush-status          Clear status variables

  flush-tables          Flush all tables

  flush-threads        Flush the thread cache

  flush-privileges      Reload grant tables (same as reload)

  kill id,id,...        Kill mysql threads

  password new-password Change old password to new-password, MySQL 4.1 hashing.

  old-password new-password Change old password to new-password in old format.

 

  ping                  Check if mysqld is alive

  processlist          Show list of active threads in server

  reload                Reload grant tables

  refresh              Flush all tables and close and open logfiles

  shutdown              Take server down

  status                Gives a short status message from the server

  start-slave          Start slave

  stop-slave            Stop slave

  variables            Prints variables available

  version              Get version info from server

However, entering any of the above only results in an error. For example,

x:~ X$ create icebb

outputs:

-bash: create: command not found

[trq]

create is not a bash command. Your getting pretty confused about what should be executed from bash and what needs to be executed from within mysql.

[Evil Glint]

I am confused. I am very confused. I literally have no idea what I need to do to put a password on the root account, log in to MySQL, or create a database. I have never use MySQL, just HTML/CSS. What do I need to do, and where?

[trq]

/usr/local/mysql/bin/mysqladmin -u root password "newpwd"