m (→Import a database) |
m (→Change password) |
||
| Line 32: | Line 32: | ||
Stop the MySQL Server. | Stop the MySQL Server. | ||
sudo /etc/init.d/mysql stop | sudo /etc/init.d/mysql stop | ||
| + | |||
| + | If this does not work, try "mysql stop/waiting" instead~[http://goo.gl/4xKOK2] | ||
Start the mysqld configuration. | Start the mysqld configuration. | ||
Contents |
MySQL is the best database we know. That's what we use.
SHOW databases;
is may be the most important command. It shows you what's in store.
CREATE USER 'laussy' IDENTIFIED BY 'mypass'; GRANT ALL PRIVILEGES ON *.* TO 'laussy';
From the command line:
mysql -u laussy -p wikilaussy < wikilaussy-24-jan-10.sql
to import the database data (wikilaussy-24-jan-10.sql, a readable file with very long lines) into the database structure (named wikilaussy) above.
See [1]:
Stop the MySQL Server.
sudo /etc/init.d/mysql stop
If this does not work, try "mysql stop/waiting" instead~[2]
Start the mysqld configuration.
sudo mysqld --skip-grant-tables &
Login to MySQL as root.
mysql -u root mysql
Replace YOURNEWPASSWORD with your new password!
UPDATE user SET Password=PASSWORD('YOURNEWPASSWORD') WHERE User='root'; FLUSH PRIVILEGES; exit;