جميع التفاصيل موضحة في الرابط التالي على ال Github.
اضغط هنا
File : /var/log/mysql/error.log
[ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
lsof -i:3306 ////Get PID ////example : COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME mysqld 2644 mysql 51u IPv4 20139 0t0 TCP localhost:mysql (LISTEN) kill -9 PROCESS (PID) sudo service mysql restart
[mysqld]
default_authentication_plugin=mysql_native_password
sudo service mysql restart
nano /etc/mysql/my.cnf
[mysqld]
default_authentication_plugin= mysql_native_password
sudo service mysql stop
sudo service mysql start
تسجيل الدخول للــــ MySQL :
mysql -u إسم الحساب -p
ثم أكتب كلمة السر
CREATE USER 'إسم الحساب'@'localhost' IDENTIFIED WITH mysql_native_password BY 'كلمة السر';GRANT ALL PRIVILEGES ON *.* TO 'إسم الحساب'@'localhost' WITH GRANT OPTION;CREATE USER 'إسم الحساب'@'%' IDENTIFIED WITH mysql_native_password BY 'كلمة السر';GRANT ALL PRIVILEGES ON *.* TO 'إسم الحساب'@'%' WITH GRANT OPTION;
CREATE DATABASE IF NOT EXISTS `DB` COLLATE 'utf8_general_ci' ;GRANT ALL ON `DB`.* TO 'إسم الحساب'@'%' ;FLUSH PRIVILEGES ;
W: GPG error: http://repo.mysql.com/apt/ubuntu xenial InRelease: The following signatures were invalid: KEYEXPIRED 1550412832 KEYEXPIRED 1550412832 KEYEXPIRED 1550412832W: The repository 'http://repo.mysql.com/apt/ubuntu xenial InRelease' is not signed.N: Data from such a repository can't be authenticated and is therefore potentially dangerous to use.N: See apt-secure(8) manpage for repository creation and user configuration details.
sudo rm -rf /etc/apt/sources.list.d/*sudo rm -rf /var/lib/apt/lists/*sudo apt-get update
apt-get update
0% [Connecting to it.archive.ubuntu.com (***********)]
/etc/gai.conf
#precedence ::ffff:0:0/96 100
precedence ::ffff:0:0/96 100
:wq
wget https://docs.google.com/uc?id=0B3X9GlR6EmbnQ0FtZmJJUXEyRTA&export=download
mv uc\?id\=0B3X9GlR6EmbnQ0FtZmJJUXEyRTA gdrive
chmod +x gdrive
sudo install gdrive /usr/local/bin/gdrive
gdrive list
Authentication needed
Go to the following url in your browser:
URL Enter verification code:
gdrive [global] list [options] List files
gdrive [global] download [options]Download file or directory
gdrive [global] download query [options]Download all files and directories matching query
gdrive [global] upload [options]Upload file or directory
gdrive [global] upload - [options]Upload file from stdin
gdrive [global] update [options]Update file, this creates a new revision of the file
gdrive [global] info [options]Show file info
gdrive [global] mkdir [options]Create directory
gdrive [global] share [options]Share file or directory
gdrive [global] share listList files permissions
gdrive [global] share revokeRevoke permission
gdrive [global] delete [options]Delete file or directory
gdrive [global] sync list [options] List all syncable directories on drive
gdrive [global] sync content [options]List content of syncable directory
gdrive [global] sync download [options]Sync drive directory to local directory
gdrive [global] sync upload [options]Sync local directory to drive
gdrive [global] changes [options] List file changes
gdrive [global] revision list [options]List file revisions
gdrive [global] revision download [options]Download revision
gdrive [global] revision deleteDelete file revision
gdrive [global] import [options]Upload and convert file to a google document, see 'about import' for available conversions
gdrive [global] export [options]Export a google document
gdrive [global] about [options] Google drive metadata, quota usage
gdrive [global] about import Show supported import formats
gdrive [global] about export Show supported export formats
gdrive version Print application version
gdrive help Print help
gdrive helpPrint command help
gdrive helpPrint subcommand help
gdrive upload file.zip
chmod 777 infusions/articles/images/ infusions/blog/images/ infusions/blog/images/thumbs/ infusions/downloads/files/ infusions/downloads/images/ infusions/downloads/submissions/ infusions/downloads/submissions/images/ infusions/forum/attachments/ infusions/forum/images/ infusions/gallery/photos/ infusions/gallery/photos/thumbs/ infusions/gallery/submissions/ infusions/gallery/submissions/thumbs/ infusions/news/images/ infusions/news/images/thumbs/
جميع التفاصيل موضحة في الرابط التالي على ال Github . اضغط هنا
Error (1) : #2054 - The server requested authentication method unknown to the client Error (2) : mysqli_real_connect(): The server requ...
|
عندما تحاول عمل الأمر التالي : apt-get update تحصل على الخطأ التالي : 0% [Connecting to it.archive.ubuntu.com (***********)] ...
|
wget https://dev.mysql.com/get/mysql-apt-config_0.8.10-1_all.deb apt-get install gdebi sudo gdebi mysql-apt-config_0.8.10-1_all.deb su...
|
Error : The $cfg['TempDir'] (./tmp/) is not accessible. phpMyAdmin is not able to cache templates and will be slow because of ...
|
جميع الحقوق محفوظه © مدونة سرحان
تصميم Sarhan Host