Databases
StackOverflow2013
Postsdbo
POReset mysql5 root password in macports
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POReset mysql5 root password in macports
    primarykey
    data
    text
    <p>I've just installed macports through macports 1.9.2 on Snow Leopard. Now I can't use mysql because it seems as if I didn't know the password.</p> <pre><code>$ sudo mysql5 -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) </code></pre> <p>I'm not sure if this is some error in the install or usage, or I just forgot the password, but I think I need to reset the password. How to do it?</p> <p>UPDATE: I can start and stop my MySql server, so it shouldn't be broken, but I don't have a command like $ sudo /opt/local/lib/mysql5/bin/mysqld_safe5.</p> <pre><code>$ ls /opt/local/lib/mysql5/bin/ innochecksum mysql_client_test mysql_secure_installation mysqlbinlog mysqlimport ndb_drop_index ndb_select_all resolve_stack_dump msql2mysql mysql_client_test_embedded mysql_setpermission mysqlbug mysqlshow ndb_drop_table ndb_select_count resolveip my_print_defaults mysql_config mysql_tzinfo_to_sql mysqlcheck mysqlslap ndb_error_reporter ndb_show_tables myisam_ftdump mysql_convert_table_format mysql_upgrade mysqld_multi mysqltest ndb_mgm ndb_size.pl myisamchk mysql_find_rows mysql_waitpid mysqld_safe mysqltest_embedded ndb_print_backup_file ndb_test_platform myisamlog mysql_fix_extensions mysql_zap mysqldump ndb_config ndb_print_schema_file ndb_waiter myisampack mysql_fix_privilege_tables mysqlaccess mysqldumpslow ndb_delete_all ndb_print_sys_file perror mysql mysql_install_db mysqladmin mysqlhotcopy ndb_desc ndb_restore replace </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USmimrock
    1. USmimrock
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POReset mysql5 root password in macports
      1. USbrutuscat
      1. VTFavorite
    2. VO
      singulars
      1. POReset mysql5 root password in macports
      1. USgoh
      1. VTFavorite
    3. VO
      singulars
      1. POReset mysql5 root password in macports
      1. USy_a_v_a
      1. VTFavorite
    1. COcheck my answer: replaced mysqld_safe5 with mysqld_safe
      singulars
      1. POReset mysql5 root password in macports
      1. UStechnology
    2. COSomething is not ok with my install: mysql> update user set Password=PASSWORD('new-password') WHERE User='root'; Query OK, 0 rows affected (0.03 sec) Rows matched: 0 Changed: 0 Warnings: 0 If I try to manually create root, it says I can't with skip-grant-tables... Reinstall?
      singulars
      1. POReset mysql5 root password in macports
      1. USmimrock
    3. COtry to reinstall.
      singulars
      1. POReset mysql5 root password in macports
      1. UStechnology
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload