前提・実現したいこと
phpで自作で作ったデータベースにアクセスしてデータを表示したいです.
発生している問題・エラーメッセージ
mysqlにアクセスできていないみたいです.ローカルサーバーにアクセスすると真っ白の状態
エラーメッセージ
該当のソースコード
データベースはこのような感じです
mysql> select * from user; +------+ | name | +------+ | yuma | +------+
php
1<!DOCTYPE html> 2<html lang="ja"> 3<head> 4 <meta charset="utf-8"/> 5 <title>Test_PHP</title> 6</head> 7<body> 8 9 <?php 10 $hostname = "localhost"; 11$username = "root"; 12$password = "パスワード"; 13$dbname = "test"; 14 15$connect = mysql_connect($hostname, $username, $password); 16mysql_select_db($dbname); 17 18$sql = "select * from user"; 19$sqlq = mysql_query($sql, $connect); 20 21while($row = mysql_fetch_array($sqlq)){ 22 echo $row['col1']; 23} 24 25mysql_free_result($sqlq); 26mysql_close($connect); 27 ?> 28</body> 29</html>
vagrantfile
vagrantfile
1# -*- mode: ruby -*- 2# vi: set ft=ruby : 3 4# All Vagrant configuration is done below. The "2" in Vagrant.configure 5# configures the configuration version (we support older styles for 6# backwards compatibility). Please don't change it unless you know what 7# you're doing. 8Vagrant.configure("2") do |config| 9 # The most common configuration options are documented and commented below. 10 # For a complete reference, please see the online documentation at 11 # https://docs.vagrantup.com. 12 13 # Every Vagrant development environment requires a box. You can search for 14 # boxes at https://vagrantcloud.com/search. 15 config.vm.box = "CentOS72" 16 17 # Disable automatic box update checking. If you disable this, then 18 # boxes will only be checked for updates when the user runs 19 # `vagrant box outdated`. This is not recommended. 20 # config.vm.box_check_update = false 21 22 # Create a forwarded port mapping which allows access to a specific port 23 # within the machine from a port on the host machine. In the example below, 24 # accessing "localhost:8080" will access port 80 on the guest machine. 25 # NOTE: This will enable public access to the opened port 26 # config.vm.network "forwarded_port", guest: 80, host: 8080 27 28 # Create a forwarded port mapping which allows access to a specific port 29 # within the machine from a port on the host machine and only allow access 30 # via 127.0.0.1 to disable public access 31 # config.vm.network "forwarded_port", guest: 80, host: 8080, host_ip: "127.0.0.1" 32 33 # Create a private network, which allows host-only access to the machine 34 # using a specific IP. 35 config.vm.network "private_network", ip: "192.168.33.10" 36 37 # Create a public network, which generally matched to bridged network. 38 # Bridged networks make the machine appear as another physical device on 39 # your network. 40 # config.vm.network "public_network" 41 42 # Share an additional folder to the guest VM. The first argument is 43 # the path on the host to the actual folder. The second argument is 44 # the path on the guest to mount the folder. And the optional third 45 # argument is a set of non-required options. 46 # config.vm.synced_folder "../data", "/vagrant_data" 47 48 # Provider-specific configuration so you can fine-tune various 49 # backing providers for Vagrant. These expose provider-specific options. 50 # Example for VirtualBox: 51 # 52 # config.vm.provider "virtualbox" do |vb| 53 # # Display the VirtualBox GUI when booting the machine 54 # vb.gui = true 55 # 56 # # Customize the amount of memory on the VM: 57 # vb.memory = "1024" 58 # end 59 # 60 # View the documentation for the provider you are using for more 61 # information on available options. 62 63 # Enable provisioning with a shell script. Additional provisioners such as 64 # Puppet, Chef, Ansible, Salt, and Docker are also available. Please see the 65 # documentation for more information about their specific syntax and use. 66 # config.vm.provision "shell", inline: <<-SHELL 67 # apt-get update 68 # apt-get install -y apache2 69 # SHELL 70 config.vm.synced_folder ".", "/vagrant", mount_options:['dmode=777','fmode=777'] 71end 72
試したこと
sqlを用いずに<echo "hello"; ?>
などはちゃんと表示されます.
phpinfo();でも調べたところmysqlの項目があったため,インストールはされてると思います・
補足情報(FW/ツールのバージョンなど)
mysqlのバージョンを確認しようと思ったら下記のような表示がされました.これが原因なんでしょうか?どなたかお願いします.
[vagrant@localhost ~]$ mysqld -v 2018-05-11T10:09:33.117204Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-05-11T10:09:33.117831Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2018-05-11T10:09:33.506578Z 0 [ERROR] --verbose is for use with --help; did y ou mean --log-error-verbosity? 2018-05-11T10:09:33.506848Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (s ee documentation for more details). 2018-05-11T10:09:33.508534Z 0 [Warning] Can't create test file /var/lib/mysql /localhost.lower-test 2018-05-11T10:09:33.509207Z 0 [Note] mysqld (mysqld 5.7.22) starting as proce ss 15421 ... 2018-05-11T10:09:33.535138Z 0 [Warning] Can't create test file /var/lib/mysql /localhost.lower-test 2018-05-11T10:09:33.535257Z 0 [Warning] Can't create test file /var/lib/mysql /localhost.lower-test 2018-05-11T10:09:33.536854Z 0 [ERROR] Could not open file '/var/log/mysqld.lo g' for error logging: Permission denied 2018-05-11T10:09:33.537036Z 0 [ERROR] Aborting 2018-05-11T10:09:33.537133Z 0 [Note] Binlog end 2018-05-11T10:09:33.537857Z 0 [Note] mysqld: Shutdown complete
回答1件
あなたの回答
tips
プレビュー