![]() ![]() Ĭhecking for corrupt, not cleanly closed and upgrade needing tables.įor security reasons the MySQL TCP/IP default port 3306 is only open to local connections. ~# chown -R mysql:mysql /media/data/mysql ~# cp -R /var/lib/mysql /media/data/mysql To move this data for example on /media/data/mysql stop the MySQL server. Mysql> INSERT INTO addressbook (name,phone,website) VALUES ('Mouser','+39 02 575 065 71','Query OK, 1 row affected (0.10 sec)īy default MySQL save the data in /var/lib/mysql. You can turn off this feature to get a quicker startup with -AĪnd make a SQL query to see the contents: Reading table information for completion of table and column names Using the mysql client utility fill the mydb database by typing: Use the SQL queries saved on the following file to create an example table called addressbook. Ĭreate a dummy database called for example mydb using the mysqladmin utility: When installation is finished check whether mysqld daemon is already running by typing:ġ979 ? S 0:00 /bin/sh /usr/bin/mysqld_safeĢ370 ? Sl 0:05 /usr/sbin/mysqld -basedir=/usr. ![]() ![]() To remember this password to have access to the MySQL DB. The installation script will ask you the password to use to access as root user to the MySQL server. If not launch the package installation by typing: ![]() Support for paging of anonymous memory (swap) To enable this function on your Linux Kernel If you got this error: " swapon: swapfile: swapon failed: Function not implemented" probably you have ~# dd if=/dev/zero of=swapfile bs=1M count=512 To enable a momentary swap memory disk on your microSD following these steps.Ĭreate on your microSD a swap file called swapfile: Session over the debug port, it will not work with the ncurses special characters sent by the installationĭuring the mysql-server Debian package installation the system ram could not be enough so we suggest Open an SSH terminal session to get the access to the Linux board command line. This tutorial illustrates how to install MySQL server on an Acme Systems board ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |