Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [nlundsten@localhost lib]$ sudo rm /var/lib/mysql
- [sudo] password for nlundsten:
- rm: cannot remove ‘/var/lib/mysql’: Is a directory
- [nlundsten@localhost lib]$ sudo rm /var/lib/mysql -rf
- [nlundsten@localhost lib]$ sudo mysql_install_db --user mysql --datadir /var/lib/mysql
- Installing MySQL system tables...2015-03-04 22:24:34 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
- 2015-03-04 22:24:34 25658 [Note] InnoDB: Using atomics to ref count buffer pool pages
- 2015-03-04 22:24:34 25658 [Note] InnoDB: The InnoDB memory heap is disabled
- 2015-03-04 22:24:34 25658 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
- 2015-03-04 22:24:34 25658 [Note] InnoDB: Memory barrier is not used
- 2015-03-04 22:24:34 25658 [Note] InnoDB: Compressed tables use zlib 1.2.3
- 2015-03-04 22:24:34 25658 [Note] InnoDB: Using Linux native AIO
- 2015-03-04 22:24:34 25658 [Note] InnoDB: Using CPU crc32 instructions
- 2015-03-04 22:24:34 25658 [Note] InnoDB: Initializing buffer pool, size = 128.0M
- 2015-03-04 22:24:34 25658 [Note] InnoDB: Completed initialization of buffer pool
- 2015-03-04 22:24:34 25658 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
- 2015-03-04 22:24:34 25658 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
- 2015-03-04 22:24:34 25658 [Note] InnoDB: Database physically writes the file full: wait...
- 2015-03-04 22:24:34 25658 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
- 2015-03-04 22:24:34 25658 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
- 2015-03-04 22:24:35 25658 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
- 2015-03-04 22:24:35 25658 [Warning] InnoDB: New log files created, LSN=45781
- 2015-03-04 22:24:35 25658 [Note] InnoDB: Doublewrite buffer not found: creating new
- 2015-03-04 22:24:35 25658 [Note] InnoDB: Doublewrite buffer created
- 2015-03-04 22:24:35 25658 [Note] InnoDB: 128 rollback segment(s) are active.
- 2015-03-04 22:24:35 25658 [Warning] InnoDB: Creating foreign key constraint system tables.
- 2015-03-04 22:24:35 25658 [Note] InnoDB: Foreign key constraint system tables created
- 2015-03-04 22:24:35 25658 [Note] InnoDB: Creating tablespace and datafile system tables.
- 2015-03-04 22:24:35 25658 [Note] InnoDB: Tablespace and datafile system tables created.
- 2015-03-04 22:24:35 25658 [Note] InnoDB: Waiting for purge to start
- 2015-03-04 22:24:35 25658 [Note] InnoDB: 5.6.23 started; log sequence number 0
- 2015-03-04 22:24:35 25658 [Note] Binlog end
- 2015-03-04 22:24:35 25658 [Note] InnoDB: FTS optimize thread exiting.
- 2015-03-04 22:24:35 25658 [Note] InnoDB: Starting shutdown...
- 2015-03-04 22:24:36 25658 [Note] InnoDB: Shutdown completed; log sequence number 1625977
- OK
- Filling help tables...2015-03-04 22:24:37 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
- 2015-03-04 22:24:37 25686 [Note] InnoDB: Using atomics to ref count buffer pool pages
- 2015-03-04 22:24:37 25686 [Note] InnoDB: The InnoDB memory heap is disabled
- 2015-03-04 22:24:37 25686 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
- 2015-03-04 22:24:37 25686 [Note] InnoDB: Memory barrier is not used
- 2015-03-04 22:24:37 25686 [Note] InnoDB: Compressed tables use zlib 1.2.3
- 2015-03-04 22:24:37 25686 [Note] InnoDB: Using Linux native AIO
- 2015-03-04 22:24:37 25686 [Note] InnoDB: Using CPU crc32 instructions
- 2015-03-04 22:24:37 25686 [Note] InnoDB: Initializing buffer pool, size = 128.0M
- 2015-03-04 22:24:37 25686 [Note] InnoDB: Completed initialization of buffer pool
- 2015-03-04 22:24:37 25686 [Note] InnoDB: Highest supported file format is Barracuda.
- 2015-03-04 22:24:37 25686 [Note] InnoDB: 128 rollback segment(s) are active.
- 2015-03-04 22:24:37 25686 [Note] InnoDB: Waiting for purge to start
- 2015-03-04 22:24:37 25686 [Note] InnoDB: 5.6.23 started; log sequence number 1625977
- 2015-03-04 22:24:37 25686 [Note] Binlog end
- 2015-03-04 22:24:37 25686 [Note] InnoDB: FTS optimize thread exiting.
- 2015-03-04 22:24:37 25686 [Note] InnoDB: Starting shutdown...
- 2015-03-04 22:24:38 25686 [Note] InnoDB: Shutdown completed; log sequence number 1625987
- OK
- To start mysqld at boot time you have to copy
- support-files/mysql.server to the right place for your system
- PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
- To do so, start the server, then issue the following commands:
- /usr/bin/mysqladmin -u root password 'new-password'
- /usr/bin/mysqladmin -u root -h localhost.localdomain password 'new-password'
- Alternatively you can run:
- /usr/bin/mysql_secure_installation
- which will also give you the option of removing the test
- databases and anonymous user created by default. This is
- strongly recommended for production servers.
- See the manual for more instructions.
- You can start the MySQL daemon with:
- cd /usr ; /usr/bin/mysqld_safe &
- You can test the MySQL daemon with mysql-test-run.pl
- cd mysql-test ; perl mysql-test-run.pl
- Please report any problems at http://bugs.mysql.com/
- The latest information about MySQL is available on the web at
- http://www.mysql.com
- Support MySQL by buying support/licenses at http://shop.mysql.com
- WARNING: Found existing config file /usr/my.cnf on the system.
- Because this file might be in use, it was not replaced,
- but was used in bootstrap (unless you used --defaults-file)
- and when you later start the server.
- The new default config file was created as /usr/my-new.cnf,
- please compare it with your file and take the changes you need.
- WARNING: Default config file /etc/my.cnf exists on the system
- This file will be read by default by the MySQL server
- If you do not want to use this, either remove it, or use the
- --defaults-file argument to mysqld_safe when starting the server
- [nlundsten@localhost lib]$ sudo service mysql start
- Redirecting to /bin/systemctl start mysql.service
- ^C[nlundsten@localhost lib]$ sudo service mysql status
- Redirecting to /bin/systemctl status mysql.service
- ● mysqld.service - MySQL Community Server
- Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled)
- Active: activating (start-post) since Wed 2015-03-04 22:22:47 PST; 2min 14s ago
- Process: 25084 ExecStart=/usr/bin/mysqld_safe (code=exited, status=0/SUCCESS)
- Process: 25073 ExecStartPre=/usr/bin/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
- Main PID: 25084 (code=exited, status=0/SUCCESS); : 25085 (mysql-systemd-s)
- CGroup: /system.slice/mysqld.service
- └─control
- ├─25085 /bin/bash /usr/bin/mysql-systemd-start post
- └─25803 sleep 1
- Mar 04 22:22:47 localhost.localdomain mysqld_safe[25084]: 150304 22:22:47 mysqld_safe Logging to '/var/log/mysqld.log'.
- Mar 04 22:22:47 localhost.localdomain mysqld_safe[25084]: 150304 22:22:47 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
- Mar 04 22:22:48 localhost.localdomain mysqld_safe[25084]: 150304 22:22:48 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
- [nlundsten@localhost lib]$ sudo tail -n50 /var/log/mysqld.log
- Warning: World-writable config file './auto.cnf' is ignored
- 2015-03-04 22:12:48 22982 [Warning] World-writable config file './auto.cnf' has been removed.
- 2015-03-04 22:12:48 22982 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: a5641d07-c2fe-11e4-bfb7-80193456190e.
- 2015-03-04 22:12:48 22982 [Note] Server hostname (bind-address): '*'; port: 3306
- 2015-03-04 22:12:48 22982 [Note] IPv6 is available.
- 2015-03-04 22:12:48 22982 [Note] - '::' resolves to '::';
- 2015-03-04 22:12:48 22982 [Note] Server socket created on IP: '::'.
- 2015-03-04 22:12:48 22982 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect file format 'user'
- 150304 22:12:48 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
- 150304 22:22:47 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
- 2015-03-04 22:22:48 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
- 2015-03-04 22:22:48 25258 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)
- 2015-03-04 22:22:48 25258 [Warning] Buffered warning: Changed limits: table_cache: 431 (requested 2000)
- 2015-03-04 22:22:48 25258 [Note] Plugin 'FEDERATED' is disabled.
- /usr/sbin/mysqld: Incorrect file format 'plugin'
- 2015-03-04 22:22:48 25258 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
- 2015-03-04 22:22:48 25258 [Note] InnoDB: Using atomics to ref count buffer pool pages
- 2015-03-04 22:22:48 25258 [Note] InnoDB: The InnoDB memory heap is disabled
- 2015-03-04 22:22:48 25258 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
- 2015-03-04 22:22:48 25258 [Note] InnoDB: Memory barrier is not used
- 2015-03-04 22:22:48 25258 [Note] InnoDB: Compressed tables use zlib 1.2.3
- 2015-03-04 22:22:48 25258 [Note] InnoDB: Using Linux native AIO
- 2015-03-04 22:22:48 25258 [Note] InnoDB: Using CPU crc32 instructions
- 2015-03-04 22:22:48 25258 [Note] InnoDB: Initializing buffer pool, size = 128.0M
- 2015-03-04 22:22:48 25258 [Note] InnoDB: Completed initialization of buffer pool
- 2015-03-04 22:22:48 25258 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
- 2015-03-04 22:22:48 25258 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
- 2015-03-04 22:22:48 25258 [Note] InnoDB: Database physically writes the file full: wait...
- 2015-03-04 22:22:48 25258 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
- 2015-03-04 22:22:48 25258 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
- 2015-03-04 22:22:48 25258 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
- 2015-03-04 22:22:48 25258 [Warning] InnoDB: New log files created, LSN=45781
- 2015-03-04 22:22:48 25258 [Note] InnoDB: Doublewrite buffer not found: creating new
- 2015-03-04 22:22:48 25258 [Note] InnoDB: Doublewrite buffer created
- 2015-03-04 22:22:48 25258 [Note] InnoDB: 128 rollback segment(s) are active.
- 2015-03-04 22:22:48 25258 [Warning] InnoDB: Creating foreign key constraint system tables.
- 2015-03-04 22:22:48 25258 [Note] InnoDB: Foreign key constraint system tables created
- 2015-03-04 22:22:48 25258 [Note] InnoDB: Creating tablespace and datafile system tables.
- 2015-03-04 22:22:48 25258 [Note] InnoDB: Tablespace and datafile system tables created.
- 2015-03-04 22:22:48 25258 [Note] InnoDB: Waiting for purge to start
- 2015-03-04 22:22:48 25258 [Note] InnoDB: 5.6.23 started; log sequence number 0
- 2015-03-04 22:22:48 25258 [Note] Server hostname (bind-address): '*'; port: 3306
- 2015-03-04 22:22:48 25258 [Note] IPv6 is available.
- 2015-03-04 22:22:48 25258 [Note] - '::' resolves to '::';
- 2015-03-04 22:22:48 25258 [Note] Server socket created on IP: '::'.
- 2015-03-04 22:22:48 25258 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect file format 'user'
- 150304 22:22:48 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
- [nlundsten@localhost lib]$
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement